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
Answers
-
Hello @John Stanik
At this time, Smartsheet doesn't support automation or formula functionality for creating children/indenting rows but its really a great idea!
Please submit an enhancement request on this to be considered for future development of Smartsheet!
Cheers~
Krissia
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!