# Multiple IF/AND for duration and status

Options

Hi Community,

I am trying to structure an IF/AND formula to reflect the following conditions:

IF [Duration]@row <> 0, AND IF [Complete]@row =0, "Not Started"

IF [Duration]@row <> 0, AND IF [Complete]@row =0, AND IF[Complete]@ previous row = 1, "In Progress"

IF [Duration]@row <> 0, AND IF [Complete]@row =1, "Complete"

IF [Duration]@row = 0, "No Task"

Could somebody kindly help? Hope the above makes sense.

Thank you!

Tags:

Options

Thank you Joanna, I ended up using:

=IF([Actual days]@row = 0, "No Task", IF(Complete@row = 1, "Complete", IF(Current@row = "Current", "In Progress", "Not Started")))

Where Current is (for row20, in this case):

=IF(AND(Complete19 = 1, Complete20 = 0), "Current", "Not current")

Best

Options

Thank you Joanna, I ended up using:

=IF([Actual days]@row = 0, "No Task", IF(Complete@row = 1, "Complete", IF(Current@row = "Current", "In Progress", "Not Started")))

Where Current is (for row20, in this case):

=IF(AND(Complete19 = 1, Complete20 = 0), "Current", "Not current")

Best

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!