I can't get the PARENT formula to work without a reference

CycleBagEd

I'd like to use the PARENT formula to retrieve the data from the parent row for a column called Task Name

If I use =PARENT([Task Name]) I get #UNPARSEABLE

If I use =PARENT([Task Name]3) in row 3 I get the parent data as expected for row 3, and if I drag the formula it auto-updates the reference. However, I then cannot turn it into a formula column because of the fixed reference, and the formula is supposed to work WITHOUT the reference.

Any ideas?

Andrée Starå

Hi @CycleBagEd

I hope you're well and safe!

Try something like this.

=PARENT([Task Name]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @CycleBagEd

I hope you're well and safe!

Try something like this.

=PARENT([Task Name]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

CycleBagEd

Thank you @Andrée Starå

I thought I had tried that already but I must not have had the syntax correct. This worked for me. Thank you!

It is also compatible with the formula column functionality.

Ed

Andrée Starå

@CycleBagEd

Excellent!

You're more than welcome!