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

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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!