Formula Help: RGB & due date, returning "Invalid Column Value"

Jason Serin
Jason Serin ✭✭
edited 06/11/20 in Formulas and Functions

This is driving me crazy. I want to display a "Green" if an item is completed, "Red" if it has not been completed and the due date is past, and nothing otherwise. I am using the following formula:


=IF(ISBLANK([Scheduled Date]@row), "", IF(NOT(ISBLANK([Completed Date]@row)), "Green", IF(AND([Scheduled Date]@row > TODAY()), ([Completed Date]@row = "blank"), "Red")))


It works unless the due date is in the future, in which case I get "#INVALID COLUMN VALUE." What am I doing wrong? If I put anything at the end to return a "yellow," I get other errors.

Thanks for your help. Jason

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!