In this video, Dan from School of Sheets will show you how to populate three different sheets automatically with one single form entry by using the copy row automation. He will also show you a simple back end to prevent erroneous data from getting transferred to different sheets.
Be sure to check out the timeline links below to jump to the section you’re interested in.
VIDEO TIMELINE
– 00:00 – Intro and Info about the Smartsheet Community Thread
– 00:12 – Smartsheet Community User’s Problem and Question
– 00:53 – Setting up the Example Sheet and Form
– 01:55 – Using Row Copy Automation to Solve the Problem
– 03:40 – Testing the Solution
– 04:25 – Protecting Against Non-Intended Information Being Copied
– 08:05 – Alternate Solution Using a Report
– 08:50 – Outro
– 00:12 – Smartsheet Community User’s Problem and Question
– 00:53 – Setting up the Example Sheet and Form
– 01:55 – Using Row Copy Automation to Solve the Problem
– 03:40 – Testing the Solution
– 04:25 – Protecting Against Non-Intended Information Being Copied
– 08:05 – Alternate Solution Using a Report
– 08:50 – Outro
If you’re interested in working with us, fill out our new client interest form HERE.
After submitting the form, you’ll have the opportunity to schedule a no-obligation 30-minute project exploration call to discuss your needs and see if we’re the right fit to help.
Resources:
- Try Smartsheet free for 30 days
- Want to work with us? Fill out our new client interest form
- Learn more about us here
