Need tip for nested formula using IF, AND, and ISBLANK

Options

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", " ")))

Current formula.PNG

Tags:

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!