Adding year to quarterly equation to count


I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected launches. Ask is for a formula that I can apply to count how many project completions there are per network, per quarter, per year while referencing another sheet's data.

Formula I have: =COUNTIFS({Expected Completion Date}, <=[Q1 dates]2, {Business Unit}, $Network@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!