PARENT Function

References the parent of the specified cell.
Sample Usage
PARENT([Task Name]6)
Syntax
PARENT(
  • [
    reference
    ]
)
  • reference
    —[optional]
    Refer to a specific cell to identify its parent. If no cell is specified, returns the parent of the current cell.
Examples

This example references the following sheet information:

Row #

Row Hierarchy

Project

% Complete

Item Value

Cost Per Unit

1

1

- Men's Formal Button Down

71%

MF01

$38.75

2

2

-- MF01 - Design Phase

100%

DP

$25.00

3

3

    Pre-Visualization 

100%

DP01

$15.00

4

2

-- MF01 - Assembly

42%

A0

$13.75

5

3

    Cutout Shirts

100%

A0

$10.00

6

3

    Sew Shirt

25%

A002

$2.50

7

3

--- Phase 2 - Hold For Now

0%

A003

$1.25

8

4

    Add Buttons

0%

A003 - 1

$1.25

 

Given the table above, here are some examples of using PARENT in a sheet:

 

Formula

Description

Result(s)

=PARENT([Item Value]5) 

Return the Parent row name of the “Item Value” column row 5. 

A0

=PARENT([Item Value]2) + "  " + "Design Phase"

Return the Parent row name of the “Item Value” column row 2. Then add the value “- Design Phase”

MF01 - Design Phase 

="Phase 2 - " + IF(PARENT([% Complete]7) < 1, "Hold For Now", “Active”)

Add the value “Phase 2 -” before the IF formula.

 

Return the percentage value for the Parent row of the column “% Complete” row 7. If the value is less than (<) 1, produce the value “Hold For Now”, if not, produce the value “Active”.

Phase 2 - Hold For Now