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 row 5 in the Item Value column 

A0

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

Return the parent row name of row 2 in the Item Value column. 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 row 7 in the column % Complete. If the value is less than (<) 1, produce the value Hold For Now, if not, produce the value Active

Phase 2 - Hold For Now

Still need help?

Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community