Row Status Indicator in Schedule

Options

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

Caroline

Best Answer

  • delaurellc
    delaurellc ✭✭✭
    Answer ✓
    Options

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

    Caroline

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!