RYGB formula with Multiple criteria

K8te

IF phase is Pending and 15 days past date then yellow, 30 days past date then red, if phase is received then green. How do I write this?

Genevieve P.

Hi @K8te

Try something like this:

=IF(Phase@row = "Received", "Green", IF(TODAY() - Date@row < 15, "", IF(TODAY() - Date@row < 30, "Yellow", "Red")))

You didn't note what you want to see if the Phase is not "Received" yet the date is less than 15 days past the date. In this instance I wrote a blank cell, but you can replace whatever colour you'd like in between the two "".

See: IF Function / TODAY Function / Use Formulas to Perform Calculations With Dates / Create a Cell or Column Reference in a Formula

If this hasn't helped, it would be useful to see a screen capture of your sheet with the column names, but please block out any sensitive data.

Cheers,

Genevieve

Genevieve P.

Hi @K8te

Try something like this:

=IF(Phase@row = "Received", "Green", IF(TODAY() - Date@row < 15, "", IF(TODAY() - Date@row < 30, "Yellow", "Red")))

You didn't note what you want to see if the Phase is not "Received" yet the date is less than 15 days past the date. In this instance I wrote a blank cell, but you can replace whatever colour you'd like in between the two "".

See: IF Function / TODAY Function / Use Formulas to Perform Calculations With Dates / Create a Cell or Column Reference in a Formula

If this hasn't helped, it would be useful to see a screen capture of your sheet with the column names, but please block out any sensitive data.

Cheers,

Genevieve

K8te

Thank you for your help. This works for me.