Column formula to reference 1 cell
I don't know why but I can't seem to get a simple formula to convert to column formula.
I would like to reference a task name in the main project line to each line in the project plan to later on use it in a separate report.
The formula is:
After trying to convert it to a column formula I get a syntax errror:
" The column formula syntax isn't quite right, see our help article."
I can't find any explanation in the help file. Both columns are "Text/ number" and copying the formula manually seems to work for all cell but I want this to be a fixed formula for new rows as well.