Nested IF Health Status Needs


I'm working on a formula to give me a health symbol based on today's relation to the due date and factoring in whether the task has already been completed (based on the presence or lack of completed date). I've messed with it a few times, but it's giving me an #INCORRECT ARGUMENT SET error.

Here is my formula: =IF(AND([Due Date]@row > TODAY(+7), NOT(ISBLANK([Completed Date]@row))), "Green", IF(AND([Due Date]@row < TODAY(), ISBLANK([Completed Date]@row)), "Red"), IF(AND([Due Date]@row <= TODAY(+7), ISBLANK([Completed Date]@row)), "Yellow"))

I'm sure I'm missing something very simple. Please let me know if additional info is needed to assist. Thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!