How to remove flags with no link date available
I have a flag column with this formula:
=IF([Start of NESV Validation]@row < TODAY(-30), 1)
The formula works fine when the "Start of NESV Validation" column has a date available. But when there's no date present, a red flag still shows.
How can I leave the flag space blank if no date is available?
If have also tried this formula as well:
=IFERROR(IF([Start of NESV Validation]@row < TODAY(-30), 1), "")
The flag still shows up.
Help Article Resources
Check out the Formula Handbook template!