Data Shuttle Specific Cell

jcaguioa

I'm currently extracting data from excel attachments from one sheet into a new sheet. It's basically a list of items with quantity and descriptions which, at the top of the excel sheet, is an ID number (cell B2). I've configured Data Shuttle to extract the rows which start at Row 13, below all the identifiers i.e. date, name. etc.. Is there a way to get a specific cell ,cell B2, to populate into each new row Data Shuttle creates? I need to know which items belong to which excel sheet.

Scott Peters

Hi @jcaguioa - Have you tried adding an expression? https://community.smartsheet.com/discussion/94939/how-to-use-data-shuttle-expressions