COUNTIF Question



I have a master list where I log all support requests with a summary of the request, due dates, ECD health ect. On my master list sheet, there is a dropdown column where I label the task health as either "in progress", "overdue", or "resolved." On a separate metric sheet, I am trying to use the COUNTIF formula that will count the number of tasks labeled with respect to the categories stated in the previous sentence. The formula is giving me issues pulling in the correct category - I'm not sure if this is because the "Task Health" column has 3 separate values, or if there is an easier way to achieve this.

The formula I've been trying:

=COUNTIF({OrthoFi RAIL - Masterlist Range 5}, {OrthoFi RAIL - Masterlist Range 15})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!