If/then statements and automation

Hi team,

I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column.

Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase column (initiate, design, plan, construct, closeout, closed).

Is there a way to set up a formula or automation to do this function?

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!