LindseyC✭

比ks Craig! I was thinking that was a way I could do it, but preferred if the rows were sent separately instead of grouped like Nofications are. Might be the only way at the moment though. Thanks for your input! :)

比ks, Kennedy!

I vote for this feature, as well!

It is possible to customize the viewing capiblities within a sheet in a shared workspace. When you click sharing in the workspace, all collaborators you add will have the same access to all sheets within that workspace. However, if you click on a specfic sheet in that workspace, then click sharing, you can add a…

Oh I see what I did. I did the same formula, but forgot to move the paranthesis. Thanks again for helping, Atus! Very much appreciated.

你好棒!是的,这是非常有用的!比ks for showing me how to add the "or" statement. Makes it very easy.

Hi Atus! Thank you so much! Once again, you are so helpful. Is possible to add a third "OR" criteria (such as if yellow or red or blue in children, then turn parent row yellow). I would assume it is, but when I tried to add in that third criteria, it comes up as an error. Thanks!

Hello! I am working on creating a variation of this formula, but can't get it to work. If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow. If there are only greens (no other color), I want the parent row to show Green. How do I do the "or" statement? Thanks for any help! Lindsey

Hi Atus, Thank you! I thought it was probably the ""+ causing the issue. I added a column, used the VALUE() formula, used the SUM() formula to add the total to the top of my sheet and then hid the additional column. It works show the information I needed. I very much appreciate your help! Lindsey

I have tried this and it comes up blank. (not an error, but a blank cell) Also, I have already have a hierarchy that is three levels so when adding an addition level, it hides the info in the last level. Thank you!