Using IF, AND, OR
Looking for formula advice/help! I would like to write a formula that will:
- Mark Past Due if Complete By is greater than today + task is not complete
- If no Complete By date exists, than Past Due flag remains unchecked
So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a Complete By date associated show as flagged. Would I use an OR in this situation? Not even sure if this is possible-- Any thoughts?
Best Answers
-
I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..
=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))
-
Hi @SPark
So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.
Cheers,
Genevieve
Answers
-
I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..
=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))
-
Hi @SPark
So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!