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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!