If Imported File Contains the Same Value in a Field Multiple Times Automatically Create Children


Okay. This is super hard to explain. Here it goes, I will be importing an excel file to smartsheet through zapier. One header field is called "Reference". I will be importing orders, and how it exports into Excel, each individual product on ONE order will have the same Reference number. For example, 5 rows might say 1290378, they are different products on one order.

I want to create a formula that would automatically indent these 5 rows that have the same value in the Reference field, and create a parent row with only a few fields filled out. I hope this makes sense. LMK if questions. Thanks so much!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!