At Risk Flag Count
I have a formula set up to capture when a flag is activated, i.e. when the Status is in the past, the flag is activated (unless the Status is On Hold, Cancelled or Complete).
I also want the flag to be activated when the Status is changed to Unresourced, but can't quite work out that piece of the formula. Please can someone help me add this function to the below formula. Thank you.
=IF(ISBLANK(Status@row), "", IF(ISBLANK(Start@row), "", IF(AND(Finish@row < TODAY(), NOT(Status@row = "On Hold"), NOT(Status@row = "Cancelled"), NOT(Status@row = "Complete")), 1, 0)))
Best Answer
-
Try this:
=IF(OR(ISBLANK(Status@row),ISBLANK(Start@row)),0,IF(Status@row="Unresourced",1,IF(AND(Finish@row < TODAY(), NOT(Status@row = "On Hold"), NOT(Status@row = "Cancelled"), NOT(Status@row = "Complete")), 1, 0))))
Let me know if it works!
Best,
Heather
Answers
-
Try this:
=IF(OR(ISBLANK(Status@row),ISBLANK(Start@row)),0,IF(Status@row="Unresourced",1,IF(AND(Finish@row < TODAY(), NOT(Status@row = "On Hold"), NOT(Status@row = "Cancelled"), NOT(Status@row = "Complete")), 1, 0))))
Let me know if it works!
Best,
Heather
-
@Heather D thanks for getting back to me. No it brings up an error that something is not quite right.
I switched the Unresourced part to the front of the formula and looks like it is working now. Thanks for getting me on the right track. I don't know how to change the response to Yes, but have Voted Up the answer.
=IF(Status@row = "Unresourced", 1, IF(ISBLANK(Status@row), "", IF(ISBLANK(Start@row), "", IF(AND(Finish@row < TODAY(), NOT(Status@row = "On Hold"), NOT(Status@row = "Cancelled"), NOT(Status@row = "Complete")), 1, 0))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!