Combining rows with like names

TWentworth

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?

Andrée Starå

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!

TWentworth

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.

Paul H

@TWentworth

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.

Andrée Starå

@TWentworth

I saw that Paul had answered already!

Let me know if I can help with anything else!

Best,

Andrée 

TWentworth

Dumb question, but how do I create the second sheet, the Roll up sheet?

TWentworth

https://community.smartsheet.com/discussion/comment/334875#Comment_334875

Can you tell me how to do this?

Petra Karber

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....