I would like RYGB column to;
- default ='Green'
- if today>[Proposed Start Date] = 'Red'
- if today => ([Proposed Start Date]-7) = 'Yellow'
- if [Actual Start] is not blank = 'Green'
I am able to default to 'Green'. I have formula for 'Red'.
I'm stuck when I try to add to my formula. The below is returning 'unparseable'. I've tried numerous things and should probably just walk away and come back later.
What am I doing wrong?
=IF(OR(TODAY()>[Proposed Start Date]@row,"Red"), IF(TODAY()=<[Proposed Start Date@row-7,"Yellow"))