Hierarchy Question

Reggie Andaya

Reggie Andaya ✭✭✭

07/31/22 in Smartsheet Basics

So I'm trying to distinguish the the differences. Is this example below correct or am I off?

0 ·

Best Answer

che.rabajante ✭✭✭✭✭

07/31/22 Answer ✓

Hello @Reggie Andaya
Hierarchy
Parent
Children
Ancestors
Descendants

Hope this helps.

0 · Share on Facebook Share on Twitter

Answers

che.rabajante ✭✭✭✭✭

07/31/22 Answer ✓

Hello @Reggie Andaya
Hierarchy
Parent
Children
Ancestors
Descendants

Hope this helps.

0 · Share on Facebook Share on Twitter
Neil Watson ✭✭✭✭✭✭

07/31/22

1 · Share on Facebook Share on Twitter
Reggie Andaya ✭✭✭

07/31/22

Thank you for clarifying 😁

0 · Share on Facebook Share on Twitter
Reggie Andaya ✭✭✭

07/31/22

@Neil Watson
So I'm having an issue withe formula below. I'm learning formulas so please bear with me😄.
Just to test, I'm trying to count the number of parents in the primary column below.
=SUM(PARENTS()) **This results in 0
=COUNT(PARENTS([Task Name]1) **This results in #UNPARESABLE

0 · Share on Facebook Share on Twitter
Neil Watson ✭✭✭✭✭✭

07/31/22

@Reggie Andaya the formula is PARENT https://help.smartsheet.com/function/parent

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Record a date when a status changes from closed to open
I have a tracker where I am tracking dates when tasks are closed, but I'm running into an issue where some items are being "reopened" for additional follow-up. What I want to do is know WHEN that happens (so I can track trends or culprits LOL). Is there a way to record a date when this happens? My record a date workflow is…
Is there a way to put a display name on a hyperlink in the Form Description?
Is this possible? I see it was asked quite a few years back and a couple people added it as an enhancement, just wanted to see if it was ever implemented?
Sheet Summary best practice - request for guidance
Hi, I have a sheet summary that is calculating the same values over and over for different categories - a total and progress counts for Fred, Wilma, Barney and Betty. What's the optimal way to do this? Should I create all values in a single sheet summary or can I create multiple summaries for the same sheet, each focused…

Help shape the future of Smartsheet.
Share your ideas and feature requests.