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.
Formula Help to change a drop down list
I am not very good with formulas and have attempted to create one, but it doesn't seem to be working.
I have a % complete column and then a "drop down" status column with "complete, in progress, not started and at risk". What I'd like to do is set up a formula that says if % complete is 100%, then status changes to "complete". If I can work it so other percentages are covered too, that would be awesome, but mainly I want the complete status.
Is this even an option? Thanks!