At Risk Flag Formula

dori.easterson91256

I have tried searching and figuring out what my formula should be, but I just can't get it. I want my flag to be red when there are 3 days or less to due date. Frustrated. See screenshot. 

Paul Newcome

Try something like this...

 

=IF(TODAY(3) >= [Due Date]@row, 1)

 

To get it to ignore the flag once the row has been checked as complete, you would use this...

 

=IF(AND(Complete@row = 0, TODAY(3) >= [Due Date]@row), 1)

dori.easterson91256

That works perfectly! Thank you so very much!

Paul Newcome

Happy to help!