Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Using Percent Value to Set Dropdown

Nick Johnson
edited 12/09/19 in Archived 2017 Posts

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
    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.




  • Nick Johnson
    edited 01/05/17

    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.

This discussion has been closed.