Input form for multiple sheets

Markus1998

I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations.

In Smartsheet, I imported each tab (input sheet and each country). I also relinked all the formulas. Can I create a Smartsheet form that will tie back to the input sheet. In other words, I want multiple users to fill out the form, but having each of their 100's of calculations separate (a new row).

Please advise.

Thanks!

Christian G.

Have you try to reference the sheet that is filled by the form to other sheets ?

If you right-click on the first cell of a column, you can "link from Cell in Other Sheet..." and then select a whole column. That way, every new row in the referenced sheet will appear in the calling sheet.

I hope I'm somewhat understandable. English is not my first language.

Markus1998

Hi Christian, I will give this a try. Thanks for the tip!

Markus1998

Hi Christian, when I tried your advice, the calling sheet (EUWWBD) only updates with with the first record from the form (InputRevised). Is there a way that it will update with the latest record index FC3?

Christian G.

Only the last record (FC3) ?

Markus1998

I would like the calling sheet (EUWWBD) to pull from the last record FC3.