jbusch30’s Profile

Community member since April 2018



Hello All, 

I am trying to automate the blue ball based on complete and the red, yellow and green based on date. I have come up with the following formula but I am getting an UNPARSE any help would be great.

=If(Status1 =Complete, "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red",


Hi Everyone, 

I have been trying to get my RYGB to automate based on the tasks dates. 

I would like from the start date to 8 days to be Green...More than 10 days from start to be Yellow and the last 5 days before the end to be Red. I have read many other threads and I just can't wrap my head around