At Risk Flag Automation
Hi There!
Need assistance with a formula.
What I have so far is:
=IF(OR([Agreed Upon Complete Date]@row < TODAY()), IF(AND([Agreed Upon Complete Date]@row <> ""), IF(AND(Status@row <> "Complete"), 1, 0)))
This is working great for if the "Agreed Upon Complete Date" is in the past and the status is not complete, turn the flag red. In addition, this formula will not return a red flag if the Agreed Upon Complete Date is blank.
What I need to ADD to this formula is:
If the "Agreed Upon Complete Date" is in the next 3 days and the "% Complete" is less than 75% turn the flag red.
Any assistance would be appreciated!
Best Answer
-
Hello @Jonna Critchley
Something like this perhaps?
=IF(OR([Agreed Upon Complete Date]@row < TODAY(), AND([Agreed Upon Complete Date]@row >= TODAY(), [Agreed Upon Complete Date]@row <= TODAY() + 3, [% Complete]@row < 75)), IF(AND([Agreed Upon Complete Date]@row <> "", Status@row <> "Complete"), 1, 0), 0)
https://www.linkedin.com/in/zchrispalmer/
Answers
-
Hello @Jonna Critchley
Something like this perhaps?
=IF(OR([Agreed Upon Complete Date]@row < TODAY(), AND([Agreed Upon Complete Date]@row >= TODAY(), [Agreed Upon Complete Date]@row <= TODAY() + 3, [% Complete]@row < 75)), IF(AND([Agreed Upon Complete Date]@row <> "", Status@row <> "Complete"), 1, 0), 0)
https://www.linkedin.com/in/zchrispalmer/
-
Perfecto! Just had to change the 75 to .75!
Appreciate your time!
-
Excellent, glad this worked for you!
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!