Parent Marked Qualified and changes status of all Children relation
If Status on the parent is marked qualified it will fill all the tasks below for this section only qualified. Which will stop all the alerts. How do I make it so it only affects this drop down and now all the ones on the sheet. And have this same situation going for all the dropdown
Answers
-
Hi Jett,
I am not sure I fully understand the problem. Could you clarify the problem you are experiencing?
CEO | Skyway Consulting Co.
Does your Dashboard need a map that updates from Smartsheet Data?
We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Smartsheet and GIS Integrations
→ Explore Smartsheet Maps (ArcGIS)
→ LinkedIn
-
Hi have many email address that each have these from down options. So when they do they first follow up they will mark it complete. If it is past due and not marked complete or qualifed it will send them an email which I have setup. Say on the second follow up they are qualified. So on the parent Line they will mark it qualified. How do I make it mark the uncompleted tasks as qualified so they do not get the overdue emails. Once it is marked qualified they no longer need the late reminders for that specific parent.
-
The only way I can think to do it is with a couple helper columns. One helper column to get the Parent name in my formula I call the column "Parent". The second helper column is where you would put your formula for the automation helper. Below is the formulas I used
Parent Column -
=IF(PARENT([Task Name]@row) = "", [Task Name]@row, PARENT([Task Name]@row))
automation helper column -
=IFERROR(INDEX(COLLECT(Status:Status, Parent:Parent, Parent@row, Status:Status, "Qualified"), 1), "Notify")
You can then set up your automation to only send notifications when the automation helper column is labeled "notify"
-
This did not work it is changing for the entire column. Not just the that specific parent child section.
-
Take the formula from @Hollie Green and apply it only to the section that you need, rather than the entire column. If you have already applied it to the entire column, flip it back to Cell Formula, then delete the ones you do not need it in.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
The only way it should return the same results to all sections is if you have the parent names the same. Below is what it should look like if the parent names are different. I just altered a previous sheet I had to match the status looking for.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!