Hi,
I'm trying to create a formula in google spreadsheet so that when a form arrives from google forms, it will be able to produce an end result of "HIGH RISK" , "MEDIUM RISK" , or " LOW RISK " based on the color count of cells from the conditional formatting on that particular row.
I have been able to use "COLOR_COUNTA" to count the particular number of colors in that row, but unable to make is as an array? so that when a form comes in i do not have to continue to drag the formula down that column.
Hi,
I would like to complete your project really at very low cost .. i am new to freelancer but having good experiences which you require to complete your project ..
So Please give a chance to serve you better..
Waiting for your positive decision in hiring me.
Thanks