Can't add formula to existing Column


I have a %complete column that is used as an input to other formulas in the sheet but has no formula added to it specifically. I am trying to add a formula to calculate the percentage based on the difference in start and end dates. This formula works well in other sheets.

However, when I try to add any logic beginning with "=" to the column, an apostrophe is added before the "=" and this prevents the logic from being seen as a formula:

'=IFERROR(IF(ISBLANK(Start@row), ....

Why is this apostrophe being added and how can I make this work properly?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!