PARENT Function

References the parent of the specified cell.
Sample Usage
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

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(

`<?php Complete]7) < 1, "Hold For Now", “Active”)</p>            </th>            <td>            <p>Add the value “Phase 2 -” before the IF formula.</p>                         <p>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”.</p>            </td>            <td>            <p>Phase 2 - Hold For Now</p>            </td>        </tr>    </tbody></table></div>?>`