How Can I update certain cells in a another sheet when a row is added to original submission sheet?
Hi, I'm new to Smartsheet
I have two sheets.
The first sheet holds information submitted via a form
The second sheet holds similar information but its data is used for a dashboard (
- Usually, an employee will submit a form and a new row will be added to the submission sheet (first sheet).
- I will take certain data points from the new row in the submission sheet and manually update certain cells in the (Second Sheet).
I want to automate this manual update process. How can have the cells in the second sheet updated once a new row is add the first sheet.
Help Article Resources
Check out the Formula Handbook template!