Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Automatic Formatting between 2 Columns
ClaireWallace
✭✭✭✭
Hello,
Can I have a Status Cell (Drop-Down List) be automatically updated to "Complete" when a "% Complete" column is changed to 100%?
Thanks!
Best Answer
-
Good afternoon Claire,
You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.
Answers
-
Good afternoon Claire,
You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.
-
Thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!