Using Today formula in date field has limitations

chad.stabler58751

Hi. I just wanted to find out if perhaps the =today() function does not work when using a sheet with begin and end dates and dependencies enabled. When I try to enter the function, it only shows the actual function statement and not today's date. However when I use this function on a sheet with only one due date column and dependencies are not enabled, the TODAY function works fine. 

Andrée Starå

Hi Chad,

You're correct, it doesn't work when you have dependencies enabled.

NOTE: Formulas aren't allowed in the columns listed above when dependencies are enabled.

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Dates

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

To further expand... It has nothing to do with how many due dates you have or even how many date columns you have. It has everything to do with dependencies being enabled. Even then... It is only in the dependency columns. You can still use the function elsewhere on the sheet even with dependencies enabled.