RYGG Automated

isalinosousa

Hi all,

I am unsuccessfully trying to create a formula for the following RYGG column:

Column [Project at Risk] with the RYGG:

• If [PROJECT START] (date) is more then a day over I want the [PROJECT@RISK] to display "RED" ball
• If [PROJECT START] (date) is less then 7 days away I want the [PROJECT@RISK] to display "YELLOW" ball
• If [PROJECT START] (date) is more then 7 days away I want the [PROJECT@RISK] to display "GREEN" ball
• If another column [ACTUAL PROJECT START] has any DATE in it (not blank) I want the [project at risk] to display a "GREY" ball

I would be extremely grateful for any information you can provide to help.

Thanks!

 

Andrée Starå

Hi,

Can you maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting