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.
Can a Date autoupdate to the current date
MTaylor
✭✭
Is there a way to set a date to dynamically update to TODAY?
For example, I have a sheet with start date finish date and duration. I want to track how many days into the project without having to update the finish date continually.
Tags:
Comments
-
Hello,
It looks like you have the dependencies functionality enabled in your sheet. Currently, formulas can't be used in cells used with dependencies, as formulas are running on the backend to calculate duration, finish date, etc.
You can use the TODAY function in any date cell that isn't being used for dependencies. More info on that function can be found in our help center: https://help.smartsheet.com/function/today
-
Can TODAY be used in conditional formatting?
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives