- [reference]
-
reference—[optional]Refer to a specific cell to identify its parent. If no cell is specified, returns the parent of the current cell.
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组装 |
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 usingPARENTin a sheet:
Formula |
Description |
Result(s) |
|---|---|---|
=PARENT([Item Value]5) |
Return the parent row name of row 5 in theItem Valuecolumn |
A0 |
=PARENT([Item Value]2) + " " + "Design Phase" |
Return the parent row name of row 2 in theItem Valuecolumn. Then add the value- Design Phase |
MF01 - Design Phase |
="Phase 2 - " + IF(PARENT([% Complete]7) < 1, "Hold For Now", “Active”) |
Add the valuePhase 2 -before theIFformula. Return the percentage value for the parent row of row 7 in the column% Complete. If the value is less than (<) 1, produce the valueHold For Now,if not, produce the valueActive |
Phase 2 - Hold For Now |
Still need help?
Use theFormula Handbook templateto 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.