Is there a better way? I'm getting #UNPARSEABLE error.
Options
Answers
-
The formula above will only count projects that have a date in 2025. If it starts after or ends before, it will not be counted. I use this method very often and know that it will work for this use case.
-
Thank you again! It works like a charm!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!