Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Mark child if Parent meets criteria
Hi-
I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2, Subcontractor =3)
Can someone please help with this functionality?
Thanks,
Mike
Comments
-
The children of each parent row are already indented underneath of it. Why are you trying to add a secondary marking to each row?
If you could give us some more info on what exactly you are looking to accomplish along with possibly some screenshots that would be extremely helpful towards finding a solution that works for you.
-
This is due to having multiple parents of the same type. See attached. If we could have a formula that automatically tags the identifier by row based on its parent...that is what I am after.
-
Another solution that you could do is remove the identifier column and add
=SUM(CHILDREN(Cost@row))
to the parents in the cost columns. Then use a sumif to get all of those.
=SUMIF([Primary Column]:[Primary Column], "Material", Cost:Cost)
It's almost always best to reduce the amount of helper columns you have.
-
I am going to agree with Luke's second recommendation. The identifier column still seems redundant as each Child row is identified by the parent row already. The only thing I would change about that is you may want to use [Total Cost]:[Total Cost] to capture your markup.
If you do in fact still want the identifiers, then I would go with Luke's first suggestion.
-
Thanks for the feedback Paul and Luke and it works as intended! FYI the reason we need the identifier is because we have one more column that I did not show that has a building location we need to further filter by.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
How do I use predecessors to ensure a portion of rows are complete before being able to go to the ne
I am wanting to use this format for pre-con to ensure nothing is missed or overlooked. I want to mitigate mistakes from our project managers to prevent project issues by not allowing them to move to t…