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

Tags:
· Share on FacebookShare on Twitter

Comments

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


    Craig

     

     

    · Share on FacebookShare on Twitter
  • Nick Johnson
    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories