If/Then to have date field modify status field.

Looking to input a formula so that changing the "start date" of a row will change the "status" in the column next to it.

Tried the following:

=IF(AND([Start Date]@row < [Est. End]@row, [Est. End]@row < [Actual End]@row, [Actual End]@row = ""), "IN PROGRESS", IF(AND([Start Date]@row < [Est. End]@row, [Est. End]@row < [Actual End]@row, <[Actual End]@row), "COMPLETE", "NOT STARTED"))

Formula that I worked on trying to get it to work.

 =IF([Start Date]@row < [Est. End]@row, "Started",

IF([Est. End]@row > [Start Date]@row, "In Progress",

IF([Actual End]@row > [Start Date]@row, "Complete", "Not Started")))

 Status overall:

Not Started

In Progress

Blocked

Complete


I keep getting #INVALID OPERATION


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!