What formula to merge excel into smartsheet?
I would like to have a Smartsheet file that holds specific order information (job name, ship date, delivery date, comments etc.).
The dates on these orders can change weekly. How can I import an excel file that has updated date information into the smartsheet file without wiping out what is already there? The information in the excel file would recognize and match the orders in the smartsheet file. Ideally, the cells that would be updated would change color to let the user know.
Is this possible?
Answers
-
This is a perfect use case for the premium add-on Data Shuttle.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!