I encounter a problem when trying to make a simple formula in calculated field. I can't reference a column with a space on its name.

For example, if my column is "Column A" :

formula : "='Column A'"

I've got an error. If I do the same with a column without a space on its name, it works great.

I've seen a lot of example around the internet, with a column name with a space and it's supposed to work, is there anything I've missed ?

  • share a copy of your sheet – user0 Apr 7 '19 at 16:19
  • 1
    Please add the textual error message – Rubén Jul 30 '19 at 13:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.