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

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. 

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams Top Contributor

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