Archived 2017 Posts
Archived 2017 Posts
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.