Is there a way to automate updating one field in Smartsheet when I update another field?


I am building a headcount tracker that has Employee Name, Employee ID, Manager Name, Manager ID as some of the fields.

The Manager Name is a dropdown where I can select the Manager. Is there a way to tie the Manager Name and Manager ID fields together so that it automatically updates and populates the Manager ID when I select a specific Manager in the Manager Name field?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!