Can a child row be auto-created when a row column status changes?
Hi,
When a row status column status changes from pending to suspend, can a duplicate row be created as a child row, and when the child row status changes from suspend to unsuspend, can another duplicate row be created as another child row?
Parent row 1, status is pending.....status gets updated to suspend
child row is created from same data in parent row 1, and status is suspend...... status is updated to un-suspend
another child row is created from same data in parent row 1, and status is un-suspend
thanks,
Peggy
Best Answer
-
Hello @Peggy
At this time, there is no direct method to automatically create rows for parent/child hierarchy based on a change within the sheet but it is a great idea! When you can, please submit an Enhancement Request to be considered for future development with Smartsheet!
Cheers~
Krissia
Answers
-
Hello @Peggy
At this time, there is no direct method to automatically create rows for parent/child hierarchy based on a change within the sheet but it is a great idea! When you can, please submit an Enhancement Request to be considered for future development with Smartsheet!
Cheers~
Krissia
-
Thank you Krissia.
-
@Peggy Reading your example, if you are trying to track the change dates for the statuses, you could do this with automations and helper columns. Not sure if the Parent/Child configuration is a necessity for your workflow, but wanted to point out there is an option for tracking the status changes. Note- it would be finite to one change per status.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives