Need tip for nested formula using IF, AND, and ISBLANK
I have a schedule template with columns for At Risk (red flag on or off), Status (Not Started, In Progress, Complete), and Risk Reason (is it at risk because of Late Start or Late End, or else blank if the flag is off).
Here is the Risk Reason we're currently using:
=IF(AND([At Risk]@row = 1, Status@row = "Not Started"), "Late Start", IF(AND([At Risk]@row = 1, Status@row = "In Progress"), "Late End", " "))
I want to modify if so that if a certain date column called Working Start is empty, the Risk Reason is "Not Yet Scheduled", or else all the other conditions we already have.
This is the formula I tried, but I'm getting UNPARSEABLE. Thoughts on what I've done wrong/suggestions for how to revise?
=IF(AND(([At Risk]@row = 1, ISBLANK[Working Start]@row), "Not Yet Scheduled", IF(AND([At Risk]@row = 1, Status@row = "Not Started"), "Late Start", IF(AND([At Risk]@row = 1, Status@row = "In Progress"), "Late End", " ")))
Comments
-
I ended up getting a suggestion from a colleague and it seems to be working, so this can be disregarded!
=IF(AND([Working Start]@row = "", [Working End]@row = ""), "Not Yet Scheduled", IF(AND([Actual Start]@row = "", [Actual End]@row = ""), "Late Start", IF([Actual Start]@row = "", "Not Started", IF([Actual End]@row = "", "Late End", "Complete"))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!