Automation workflow for updates that only applies to Subtasks
We are working on a software update project that we would like to automate update reminders to be sent out but we only want it to apply to the subtasks and not to the parent tasks. There was another member of the community with a similar question (https://community.smartsheet.com/discussion/84697/how-can-i-set-a-workflow-automation-for-subtasks) but this requires adding addition rows to identify the dates of the parent task vs the sub task, this seems labour intensive for a function that intuitively should be possible without additional administrative effort.
Answers
-
You can create a helper column....I use something like the following, just change the [Parent Row Name] to your column name.
=COUNT(ANCESTORS([Parent Row Name]@row)) + 1
Then you use the automation to run when it's not "1", which would be your parent rows. Try that.
-
Thanks Pam, I will give it a try. I was hoping that there is a formatting character for the indent that could be used to filter parent vs child lines.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!