Flag should turn red whenever over due day is over 30 days and status is not completed
I have a 'risk' column with flag, it is supposed to turn red whenever status does not indicate 'completed' and 'due day' is already beyond 30days, except if the status was cancelled.
I used the formula below but all the flags turned red automatically, I do not know what I am doing wrong, please help:
What is the best way to use current user guide that everyone responsible for task will only see their task and not concern with others?
=IF(AND([Days to due Date]@row < -30, Status@row <> "Completed"), 1, 0)
Help Article Resources
Check out the Formula Handbook template!