I asked this before and thought that it was working -- but today I realized it is not.
This is the formula that I am using so that an item is flagged if it is not 100% complete and the complete by date is today or three days prior: =IF(AND([Complete By]@row >= TODAY(-3), [% Complete]@row < 1), 1, 0)
The complete by date on my item is 6/15/20 and it is flagged. Why is this happening? Clearly it is not an item in jeopardy.
Help Article Resources
Check out the Formula Handbook template!