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 - No, a formula loaded into SS by DataShuttle would still need to honor the Smartsheet syntax for formulas. I don't know what the name of your column 'B' is in Smartsheet, but if we pretend that the column name will be "ID Number", then the expression would be "=[ID Number]2". If you want every row to load the content from row 2, then it would be "=[ID Number]$2". The main point here is that the column you are mapping to Excel's 2nd column (B) needs to already be set up in Smartsheet with a name that you can reference in the your formula.

Here's a link to Smartsheet's official learning track on this topic: https://help.smartsheet.com/learning-track/data-shuttle/upload-workflow

Scott Peters

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

jcaguioa

https://community.smartsheet.com/discussion/comment/456597#Comment_456597

I've tried and tested without success. For the Expression, would "=B2" be correct if I need that specific cell in the excel spreadsheet?

Scott Peters

Hi @jcaguioa - No, a formula loaded into SS by DataShuttle would still need to honor the Smartsheet syntax for formulas. I don't know what the name of your column 'B' is in Smartsheet, but if we pretend that the column name will be "ID Number", then the expression would be "=[ID Number]2". If you want every row to load the content from row 2, then it would be "=[ID Number]$2". The main point here is that the column you are mapping to Excel's 2nd column (B) needs to already be set up in Smartsheet with a name that you can reference in the your formula.

Here's a link to Smartsheet's official learning track on this topic: https://help.smartsheet.com/learning-track/data-shuttle/upload-workflow