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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!