If/Or Question

PeggyLang

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"))

Leibel S

@PeggyLang

I think the below is what you are looking for, the basics you had, just had to change the syntax a bit

=IF(TODAY() > [Proposed Start Date]@row, "Red", IF(TODAY() >= ([Proposed Start Date]@row - 7), "Yellow", "Green"))