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

=[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

Find more posts tagged with

Formulas

Comments

Frank Falco

If the date column is assigned to either the start or end date columns and you have dependencies enabled in your project settings you cannot have a formula on it. These fields are calculated my SmartSheet based on the dependencies.

The project settings are accessible in the Gantt View via the cog (settings) icon under the Share button.

Paul Newcome

Frank is correct. It seems as if you have your dependencies enabled and are using that column as one of your project columns. You have a few options...

1. Disable dependencies in the Project Settings.

2. Create another column for the calculated dates.

3. Select a different column in your Project Settings.

4. Add lag/lead time if establishing predecessors.

lcl7890

Thank you, Frank and Paul!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…