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

Ryan Hackman
edited 12/09/19 in Archived 2016 Posts

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!


This discussion has been closed.