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.