I have this formula but I am not sure where to go next =IF(Done@row = 1, "Green", "Yellow")

jurgen93

I have this formula but I am not sure where to go next

=IF(Done@row = 1, "Green", "Yellow")

I have 3 columns, one is a checkbox column, one is a text column showing times in text form, and one is a symbol column with Green, Yellow and Red options. I want the color to change to green if checkbox is checked and stay Yellow if it is not. However if the actual time is greater than in the Time column I want the symbol to go RED.

So there are a total of 2 checks. The logic is below:

IF Done = "Checked", make Status = "Green"

IF Done = "Unchecked", make status = "Yellow"

UNLESS

IF actualTime > Timing , make Status = "Red"

Can someone pls help me with this.

malanto

Hi,

I still don't know much but I'll try to help you.

You could create a new datetime column, for example modification date, to update every time you want to update the data (or you can create a workflow that updates it) and then use this formula

=IF(Timing@row < RIGHT([Last change dt]@row; 5); "Rosso"; IF(Done@row = 1; "Verde"; "Giallo"))

I'm waiting for news from you 
;-)