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?