Automatically Create Parent Row From Child/Children

clairehunter
✭✭
What will be imported is the white (2,3 & 5,6,7) rows. I want a parent (ex: orange rows 1&4) to be auto-created for any unique number in the "Reference" field. Any help would be appreciated! Thank you!
Tags:
Answers
-
As far as I know, there is no way to automatically import and create parent/child relationships unless you use the API or Bridge.
If you’re using the API directly or using Bridge you can specify hierarchy when you add or update rows..
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!