Row Status Indicator in Schedule


Wrote a formula to check two items and change and indicator light. Here is the code but it is saying incorrect argument set?

=IF(Status@row <> "Complete", [Due Date]@row < TODAY(), "Red", IF(Status@row <> "Complete", [Due Date]@row >= TODAY(2), "Yellow", "Green"))

I have reviewed everything multiple times and cannot figure out what I am missing, I even verified with formula template. What am I doing wrong here?

I am writing in notepad and transferring over to the formula builder


Best Answer

  • delaurellc
    delaurellc ✭✭✭
    Answer ✓

    I figured out the code and here it is in case anyone is trying to do the same thing

    =IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(AND([Due Date]@row = TODAY(2), Status@row <> "Complete"), "Yellow", "Green"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!