Why do my Cells revert to previous value after formula saved properly?

I click save and then it does this:

If I double click in the cell to see the formula it adds a ' at the beginning


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!