Is there a way to use automation across grids?


We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and added it to the grid?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!