If/Or Question

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

Tags:

Answers

  • Leibel S
    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"))