Formula Help - Automating Status

Lchicklis ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi there,

I am wondering if its possible to use a formula to automate a status column. For example, when someone submits an intake request through a form and a new row is added to my sheet, is it possible to have the status automatically change to "Intake"? Further, when someone approves the intake (i.e. Laura Approval column changes to 'Approved'"), can the status change to "Charter"? Not sure where to start to do something like this. Any help is much appreciated! 

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!