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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!