"IF/AND" returning #INVALID DATA TYPE"

Options

Hello, Guys

Please, can you help me to fix this formula?

=IF(AND([Start (plan)]4 < TODAY(); [Start (real)]4 = ""; "Red"); IF(AND([Start (plan)]4 = TODAY(); [Start (real)]4 = ""; "Yellow"); IF(AND([Start (plan)]4 > TODAY(); [Start (real)]4 = ""; "Green"))))

It is returning "#INVALID DATA TYPE". The "Start (real)" and "Start (plan)" columns are both "date" columns.



What I am trying to do with this formula is show a task RYG status based on the column "Start (plan)" when the column "Start (real)" is empty. But I need some help also to see if I´ve got the best solution for this here in my formula.

 

I would appreciate your help so much.

 

Cheers, Julieta.



 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!