Is there a way to allow a form user to "Add" additional fields

I'm attempting to set up a form submission where my team will provide updates on projects we work weekly. I would prefer for the form to have the option to select the name of the project that has updates then fill in a text box with the update. THEN the team would have the ability to "add" another project from a list at this time and then input updates for the second project.

Is this possible in smartsheet without having to create a new column/field for every single project a team could be working on and potentially need to submit updates for?

Tags:

Best Answer

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    Answer ✓

    Short answer: No.

    Longer answer: You could create 2+ sets of update fields and show/hide those fields based on a form checkbox or whether someone fills out Project 2, Project 3 etc name fields, using form logic.

    There are other ways to collect updates without having to use a form. One of the best ways is to setup an Update Request automation on your sheet where you list the projects. Set the automation to run on a schedule. It will email the project owner/PM and include a button in the email for them to click. When they click the button, a web form is presented with the fields that you choose to include in the update request. There's no logic on these update forms, but they do work like standard web forms that everyone is familiar with.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    Answer ✓

    Short answer: No.

    Longer answer: You could create 2+ sets of update fields and show/hide those fields based on a form checkbox or whether someone fills out Project 2, Project 3 etc name fields, using form logic.

    There are other ways to collect updates without having to use a form. One of the best ways is to setup an Update Request automation on your sheet where you list the projects. Set the automation to run on a schedule. It will email the project owner/PM and include a button in the email for them to click. When they click the button, a web form is presented with the fields that you choose to include in the update request. There's no logic on these update forms, but they do work like standard web forms that everyone is familiar with.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN