Skip to content

How to show cell hierarchy values

jambla

jambla ✭✭

12/17/18 edited 12/09/19 in Formulas and Functions

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

Screen Shot 2018-12-17 at 1.00.44 PM.png

Tags:

Formulas

0 ·

Comments

jambla ✭✭

12/17/18

I found the solution to my question: JOIN(ANCESTORS(Vaule1))

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Using =MAX( to get latest date on Dashboard
HELLO! I am trying to get the very last date on a sheet to display on my dashboard. I am using the MAX function to return the date but I keep getting an error…..I have tried the below =MAX({Target Com…
Answered ✓
Sheets
Formulas
Dashboards
Formulas and Functions
8
12:34 pm
2
Does NOT contain formula
I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment -…
Answered ✓
Formulas and Functions
15
Apr 29, 2025
2
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
Answered ✓
Countif
IF(
Formulas and Functions
21
Apr 28, 2025
1