Using formulas in date fields which reference another field

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 ( and reference another cell in the 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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!