Is it possible to see which form was for entries on a sheet?
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?
Best Answer
-
Andrée Starå ✭✭✭✭✭
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.
1
Answers
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!
@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.