Sign in to join the conversation:
Is there a way to show the values of cell hierarchy no matter the amount of parent/child?
In this example (see screenshot) I would like to output: 121b1a
Thanks
I found the solution to my question: JOIN(ANCESTORS(Vaule1))
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
Im doing cumulative formula and the cells will not format properly. Tried moving the info to a new sheet but still wont format. Help! IF([Column 26]72 = 0, "", VALUE([Column 26]72) + VALUE([9]@row ))
Need some help with a formula that doesn't seem to be working. For context, here is a description of the sheet setup and formulas I'm using (+ I've attached an image with screenshots of all the pieces as a visual aid). The sheet I'm working on is our RAID log template that we have built into our control center solution. We…
