Status Update Formula

Martha Hemingway

Hi team, I have lost one of my most favorite formulas as a project manager. Here's what I'm trying to accomplish:

If % Complete is 100% - select "Complete" for the status column.

If % Complete is between 1-99% - select "In Progress" for the status column.

If % Complete is 0% - select "Not Started" for the status column.

Thanks all!

Adam Murphy

Hi @Martha Hemingway, try something like this:

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row < 1, "In Progress", "")))

Adam Murphy

Hi @Martha Hemingway, try something like this:

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row < 1, "In Progress", "")))

heyjay

https://community.smartsheet.com/discussion/140284/status-update-formula

=IF([% Complete]@row  = "", "", 
IF([% Complete]@row  = 1, "Complete", 
IF([% Complete]@row  = 0, "Not Started", 
"In Progress")))