Nested IF Formula for Flag functionality
My sheet has an End Date, Actual Date and Late column. The Late column shows a flag.
I want to show flag red when
- the Actual Date is blank, but the End Date is today or in the past - AND
- the Actual Date is past the End Date
Here is what I have so far, but I'm getting an INCORRECT ARGUMENT SET error:
=IF(AND(ISBLANK([Actual Date]@row), TODAY() > [End Date]@row, [End Date]@row <= [Actual Date]@row, 1, 0))
Thank you for any tips!
Help Article Resources
Check out the Formula Handbook template!