Is TODAY() supported as a Sheet Summary Field?
I am trying to get a sheet summary field on my project plan to count the number of tasks which have fallen behind plan. However I do this, I am using the TODAY() function, either in a sheet column or in the summary field itself. Here is one example of something I tried in the sheet summary field:
=COUNTIFS(Status:Status <> "Done", [End Date]:[End Date], <TODAY())
I have also simply added a formula to test in Sheet Summary:
These both fail so I assume its not supported, or am I doing something silly?
Any thoughts on how to achieve what I am trying to do?
Help Article Resources
Check out the Formula Handbook template!