How to create children in large sheet automatically


Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see screenshot for detail). The bottom line is that I'd like to quickly/easily make each row with a date in the primary column the parent of the rows beneath it that start with a "--".

Thanks for any input!

John Stanik RN, BSN


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!