Is it possible to see which form was for entries on a sheet?

08/30/21
Accepted

I can't figure out how to use a sheet with multiple forms and then how to tell which entry was submitted using which form. For instance, I am sending out 6 different forms that all belong to one sheet. These forms all of slightly different information on them. Then, those people all respond and I have a sheet full of 20 submissions. How do I see which submission was submitted using which of those 6 forms? I've resorted to just only using 1 form per sheet so that I know the submissions were from that form. But, then why have the option to allow multiple forms per sheet?

Tags:

Best Answer

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Answer ✓

    Hi@Samuel Cohen

    I hope you're well and safe!

    You can add a so-called helper column with information about the form and then use the Default Value in the form set up to include it for each form.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

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

    了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Answer ✓

    Hi@Samuel Cohen

    I hope you're well and safe!

    You can add a so-called helper column with information about the form and then use the Default Value in the form set up to include it for each form.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

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

    了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Actually yes! That solved it. Thank you!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Samuel Cohen

    Excellent!

    Happy to help!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign InorRegisterto comment.