Status and % Complete co-dependency formula

Juliaprans

Hi there,

 

I am trying to figure out how to get Smartsheet to automatically change "status" column to "Completed" when I enter 100% in the "Complete" column, as well as to "Started" when I enter any % higher than 0%, and to "Not Started" if the % is 0. Is there a way to do this? Thanks!

 

 

Andrée Starå

Hi Julia,

Try this.

=IF([% Complete]@row = 1; "Completed"; IF([% Complete]@row = 0; "Not Started"; "Started"))    

The same version but with the below changes for your and others convenience.  

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Juliaprans

Hi Andre,

 

Thank you so much for your response. I get a #Unparseable error. Maybe I am not entering it correctly. I attached the screenshot.

 

Thank you!

 

Julia  

Andrée Starå

Hi Julia,

Yes, your formula is not correct.

Because I use @row in the formula, you don't need to tell which row to reference if you don't want to reference another row. The = 1 in my formula is the same as 100% so your 2 above would be 200%.

Try this

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

Did it work?

Best,

Andrée