Data from one sheet form to populate another

I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to sheet one (main sheet) via the form to then auto populate the required cells in the other sheet. Example below in the photos is when the form is filled out, how can I get the field Builder to populate from main sheet to the other. Any help is very appreciated. Thanks in advance.

2019-04-12 10_41_58-EWP Design Request Form - Smartsheet.com_.png

2019-04-12 10_40_09-(1) EWP Design Request - Smartsheet.com_.png

2019-04-12 10_43_23-(1) EWP LOG - Smartsheet.com_.png

Find more posts tagged with

Forms

Construction

Sheets

Formulas

Cell linking

Comments

Viktoria B.

Hello,

Its possible with a sheet which is capturing the form submissions (Main sheet) - and a report.

The sheet capturing the form data (Main sheet) should contain all columns from the report though, however not all column should be feed by the form - you can change them manually after the submission.

The report you are going to create will have the columns of your sheet 2.

Andrée Starå

Hi,

To add to Viktoria's answer.

As a workaround, you could use a third-party service like Zapier or similar to copy information from the main sheet to sheet 2. You could also use the Smartsheet API.

Would any of those options work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…