Formula

Need help with a formula: Need to look up only 2023 projects labeled as that in the Year Project Started/Approved in the Master Summary sheet. The formula below counts everything. Thoughts? 

 

=COUNTIFS({Project Status}, $Label@row, {Master Summary Sheet ITS PMO | Division}, [Category 1]$1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!