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

Current formula.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!