Using COUNTIFS to reference another sheet

edited 02/24/23 in Formulas and Functions

I am using a count if formular to get a project count by status and incoming year. Not sure what I am doing wrong but here is my formular. Label@row references project status - in this case "Not Started". I get an output of zero but there are 10 projects with this status.

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, AND(@cell = "2023"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!