Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Question about IF AND formula
I'm trying to use this formula on my smartsheet to create a column indicating "Late" if the phase is not closed and behind schedule, or "Missed" if the phase was approved, but after the target due date. It is coming back UNPARSEABLE. I apprecate any insight into what I'm doing wrong! Should I be using ISBLANK instead of if the submitted date = 0?
=IF(AND([Phase Target Date]2 < TODAY(), [Phase Submitted Date]2 = 0), "Late", IF([Approved Date]2 > [Approved Target Date]2, "Missed", "")))