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 Smartsheet Formula Template to view examples and practice working with functions in real-time.

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