Parent Children IF CONTAINS query
Hello! I've tried multiple versions of formulas that work for this at the parent level only, but I'm looking for a column formula that will not change the value of the children.
I have a timesheet that has the period end date as the parent and the days within that period as the children. The last child includes a timecard due date plus approvals from the supervisor and HR. I'd like a formula that returns:
- If a child supervisor approval status is "submitted", "declined", or "in process", the parent row is "in process"
- If a child supervisor approval status is "approved", the parent row is "approved"
- If the children are all blank, the parent row is blank
I need the same type of column formula for the HR approval:
- If a child HR approval status is "returned for corrections", the parent row is "returned for corrections"
- If a child HR approval status is "approved", the parent row is "approved"
- If the children are all blank, the parent row is blank
Answers
-
Hi @Nicole Arnold
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
Or if you like to fix the formula directly on your sheet please share me as an admin on a copy of your sheets ( Source & Destination ) and i will write the exact formula for you then you can copy it to your original sheet.
My Email for sharing : Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks @Bassam Khalil. I did load a file (twice) but for some reason it did not upload, and the system also cut off my question. I'll try again now. Thank you!
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
@Bassam Khalil I see the photo did load this morning...
-
Sorry am out now, I will check it for you tomorrow.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I hope you're well and safe!
Unfortunately, it's not possible now to make it a column formula because you can't have a formula and change the value as well, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Here's a possible workaround or workarounds
- Add it manually to all parents or add a so-called helper column.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Oh, bummer @Andrée Starå ! That explains my issue though. Thanks!
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!