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. 

 

Shaine Greenwood

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

MTaylor

Can TODAY be used in conditional formatting?