So, I am trying to set a trigger flag to be checked when a request is within a certain amount of days and not approved or denied. I would like the flag to trigger a reminder email to the approver indicating the request is imminent and they have yet to approve/deny it. I can't seem to get the IF/And function to work properly. Or if you guys know of a better way to go about this I am all ears! I have tried:
I am able to get the flag to check strictly with:
=IF([Need by Date]@row + 10 < TODAY(), 1, 0)
But I don't want to send the reminder if they have already completed their approval task.
I really appreciate any help with this!
Help Article Resources
Check out the Formula Handbook template!