I would like to pull in data from mulitiple smartsheets to one for payroll

Lori Hilt

We have commissions, on call pay, etc. That all have a smartsheet form that employees complete and data goes into different workbooks. We would like to pull that into one smartsheet. We only need paycodes, employee numbers and the amount. Is there a way to make this happen?

Amber Eakin

Hi @Lori Hilt - Would it be possible to set up a report, group by employee number, and then create a summary for the amount? That would should you how much total for each employee.

Andrée Starå

Hi @Lori Hilt

I hope you're well and safe!

To add to Amber's excellent advice/answer.

Another option. (I'd recommend trying the Report option first)

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

To connect them row by row, you could use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you need in the Destination sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Lori Hilt

Thank you for your input. I am going to work with it and see what I can come up with.

Andrée Starå

@Lori Hilt

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!