Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create less work for the actual smartsheet user?
Answers
-
Hi @TWentworth
I hope you're well and safe!
Not sure I follow! Can you elaborate on how you'd like it to work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
When the participant submits their weekly activity via a form, we would like to have the rows combine, so we don't have so many rows. I am not sure if this makes sense or not. So when there is a like name, or email, the info from all the different rows combine together.
-
Yes it is possible using multiple sheets
Sheet A would be where all the form submissions go to, this sheet is in the background no one looks at it.
Sheet B would be a roll up sheet. Using an email address as a unique identifier, Join(Collect cross refence formulas could combine all entries into a single row.
-
I saw that Paul had answered already!
Let me know if I can help with anything else!
Best,
Andrée
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.
-
Dumb question, but how do I create the second sheet, the Roll up sheet?
-
Can you tell me how to do this?
-
I am interested in something similar! I am collecting skill information from a form...but if the manager completes the form multiple times for their employee I want all of the skills on one row for that employee....
