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.
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?
