Using formulas in date fields which reference another field

lcl7890
lcl7890
edited 12/09/19 in Formulas and Functions

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

=[Start Date]42-10

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?

Screen Shot 2019-10-22 at 2.30.23 PM.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!