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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!