Data Shuttle Specific Cell
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.
Tags:
Answers
-
Hi @jcaguioa - Have you tried adding an expression? https://community.smartsheet.com/discussion/94939/how-to-use-data-shuttle-expressions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives