ANCESTOR_PARENT_CHILD

Archie Villa

Hello Everyone,

Good day.

I will be creating a KPI set (dashboard) for a company that will summarize its average leadtime from a PROGRAM level , ITEM level and TASK/ITEM Level.

Is there a formula i could use to identify which is an Ancestor, parent or child?

LINK: https://app.smartsheet.com/b/publish?EQBCT=a50bbcf3cf3f4b579b9a19cbb71b5659

thank you,

Archie

Paul Newcome

You would put this into a column

=COUNT(ANCESTORS())

0 = Grandparent

1 = Parent

2 = Child

Paul Newcome

You would put this into a column

=COUNT(ANCESTORS())

0 = Grandparent

1 = Parent

2 = Child

Archie Villa

Thank you Paul.

Paul Newcome

Happy to help. 👍️