Dashboard Formula for Projects Within Date Range
Hi there, I'm trying to add a widget to my dashboard that tracks how many projects were initiated by year. In the dashboard metrics sheet, I reference the project intake sheet but cannot get the correct formula to count the number of projects by year. For reference, on the project intake sheet, the due date column has the full date (mm/dd/yy). I could be doing this completely wrong but thinking if anyone has experiencing creating a similar formula while referencing another sheet, perhaps you have some insight.
Thanks so much!
Help Article Resources
Check out the Formula Handbook template!