Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Formula

Zoe McInerney

Zoe McInerney ✭✭

04/09/17 edited 12/09/19 in Archived 2017 Posts

Hi. I have finish dates for tasks and need to start them 120 days prior to that. How would I write that formula. Thank you!

Tags:

Formulas

0 ·

Comments

Adam Overton Employee

04/10/17

=[Finish Date]2 - 120

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

resource management
is there any way to access resource management features of smartsheet without having administrator privileges?
Does NOT contain formula
I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment - Ending Date] @row. This part of the formula works I can't get the third party to work. The third part should say if it DOES…
Rename labels when using custom colours
I am using Symbols in my sheet for 'risk level' using the standard Red, Yellow & Green. I then have a report showing how many/what percentage of risk we have per risk status above. I have added the report as a widget into a dashboard and am using my companies branded colours in a donut chart, however the label of each…