Input form for multiple sheets

Markus1998 ✭✭
edited 10/17/22 in Formulas and Functions

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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!