Date Function

TM ✭✭

02/22/18 edited 12/09/19 in Smartsheet Basics

How do auto date on a particular cell ?

Like a date (auto generated) 10 days prior to due date?

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

02/23/18

=[Due Date]23 - 10

for row 23 and the [Due Date] column should get you what you want.

Craig

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Controlling Asset Permission Levels
I have a feeling the answer is NO, but wanted to confirm. We are considering upgrading our Enterprise plan, but need to consider the significant price increase if we upgrade, so we are looking to cost structure variations based on what our users are doing in Smartsheet. We want to control the assets being shared not only…
Is there a way to start a task as soon as possible with a FF dependency?
What I'm looking to do is create a finish-to-finish dependency where the end date is extended but not the duration for a given task. This way a task can start immediatly but it may finish later than the duration. This way the duration of the task can outgrow the FF dependency but never be less than the FF dependency end…

Help shape the future of Smartsheet.
Share your ideas and feature requests.