Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

What is the best way to approach a form where the same field needs to be used multiple times?

We are building "product installation forms" for our sales team. Their current design for these is a 10-page PDF which is composed of individual tables for each product type (1 example attached). We have roughly 8 product types with some products having quite a few variables for design/setup.

PDF PIF setup.jpg

In building a Smartsheet form (11 forms) for this, I created one section on the form where all the products a client is signing up for would have to share a field for their packs (how the money gets distributed - shown in example below). Well, our sales team HATES it. We could have a client sign up for 15+ products at a time and when its only 2-3 products at a time, they said the excel file solution is inefficent. They want every product to have its own set of packs (3-5 fields) and of course "a table or a chart format would be ideal" (I know Smartsheet does not have that capability).

Packs.jpg

Our sheet is already 140+ columns wide and adding that many additional fields would not be manageable for our operations team.

Is the "attach an excel file" helper instruction the only way/the best way to go about this???

Tags:

Answers

  • Community Champion

    What is the best way to approach a form where the same field needs to be used multiple times?

    Hi,

    I hope you're well and safe!

    I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic day!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Trending in Smartsheet Basics