how to get a form on smartsheet to automatically send to a certain manager based on type

Vanessa COWDIN
edited 10/06/20 in Formulas and Functions

In a recent video that was posted by John Cicero, he spoke about having the form automatically update the sheet with which manager that intake request should be submitted to. He used a "Match&Index" formula, although he did not show us the steps on which how he did this. I tried to read the help pages on Smartsheet showing how to do this, but it didn't help my situation. Would you kindly show me the baby steps on how Cicero did this?



Best Answer


  • Vanessa COWDIN
    edited 10/06/20

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!