Using Percent Value to Set Dropdown

Nick Johnson

I am trying to use a formula to set a dropdown value based on the percentage value. Here is the formula I am using:

 

=IF([Percent Complete]7 = 0, “Not Started”, IF([Percent Complete]7 < 0.26, “Just Started”, IF([Percent Complete]7 < 0.74, “Working”)))

 

I am setting the formula in the dropdown cell and continue to receive #UNPARSABLE.

 

I also tried the formula in the reverse and get the same result.

 

I began with the Project template and have already removed the two columns from dependencies. 

J. Craig Williams

Try this:

 

=IF([Percent Complete]7 = 0, "Not Started", IF([Percent Complete]7 < 0.26, "Just Started", IF([Percent Complete]7 < 0.74, "Working")))

 

Did you, by chance, edit the formula somewhere else and copy/paste it in?

The formula you gave is using curly quotes (“ ”) not straight quotes ("")

Smartsheet does not like those.

 

Hope this helps.

Craig

 

 

Nick Johnson

Thank You Craig, that worked. Yes I did paste it in. I like to work in a text editor, I find it a little easier. I'll pay attention to the quotes from now on.