How can I combine rows?

I have 1 sheet with 3 forms. As the project goes along, 1 individual will complete each of the 3 forms. This will generate 3 separate rows on the sheet. I want to combine the data from all 3 rows into 1 row. Can this be done?

Answers

  • Ric T
    Ric T ✭✭✭✭✭

    Hi @Stacy Weber, I'd recommend using the Update Request automation. One suggestion is to retain one form, and automate the other two forms into update requests. As the individual completes it, an update request can be sent to them (you can customise time and trigger), with the relevant columns you need them to view and edit. This way all your information stays within the same row.

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

    Hi @Stacy Weber

    I hope you're well and safe!

    To add to Ric's excellent advice/answer.

    • Another option depending on if the form + update request would work and you don't need the form features for the whole process.
    • Using three different sheets, either have the form move the rows to a specific sheet or have a form per sheet, and then, using cross-sheet formulas and a unique ID, collect it back together in the main sheet.

    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

    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:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Thank you for the responses. I don't think the Update Request will work for us so I'd like to understand more about the separate sheets. Can I still have all 3 forms on 1 sheet and then use a formula to pull the data with a unique identifier to 1 row on a different sheet? If so, 1) what formula would this be? 2) can the supporting sheet and rollover sheet be saved together as a template?

  • Hello - following up on my comment. Can you please assist in how to combine data from multiple rows into 1 row? Would the Join/Collect formula work? If so, could you provide assistance in how to use it?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!