Using Today formula in date field has limitations

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.

Using Today formula on dependency enabled sheet.PNG

Find more posts tagged with

Sheets

Calendar View

Formulas

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…