Using formulas in date fields which reference another field
I'm trying to enter a formula in a date field which is 10 days earlier than the date in another field. I read that I can perform calculations on date fields (https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates) and reference another cell in the formula (https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula).
My formula is
because I want the date that is 10 days earlier than the cell in row 42 of the "Start Date" column.
However, when I enter this formula in the cell and hit Enter, all I see is the formula itself. See attached screenshot. What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!