Formula to Trip a Flag
Hello,
I currently have a formula in my sheet that trips the Flag function in my "At Risk" Column if the due date is less than today, and the status is NOT waived. The formula below works great. However, I would like to include "PFiled" and "Efiled" to the status already referenced, but I'm stuck. Can you please assist?
=IF(AND([End Date]110 < TODAY(), NOT(Status110 = "Waived")), 1, 0)
Best Answer
-
Try using an OR function nested within the AND function.
=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)
Answers
-
Hi Michele,
Where are the PFiled and Efiled values located?
Edit: I noticed that you mentioned status. Then Pauls formula below should work.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Try using an OR function nested within the AND function.
=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)
-
Hi Paul -
Thanks for reaching out! I copied and pasted your formula into one of the cells in the At Risk column that had Waived and Pfiled as the Status and it didn't work. However, after tweaking it for a bit, I got it to work using this:
=IF(AND([End Date]@row < TODAY(), AND(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)
Thanks so much for your help, as you at least pointed me in the right direction.
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!