Reference a sheet and count the number of a specific health icon based on status.


I am referencing a project schedule in a sheet where I am counting the total number of rows that have a specific health icon color. Green, Yellow, and Red were all straightforward to get totals for. My formula for those is: =COUNTIF({Project Schedule - Health Column}, [Health Icon]4) for each different health icon.

I also have a gray health icon in the mix, and I would only like to count those gray health icons that do not have a status of "N/A". For reference see a screenshot of the different options I have in the dropdown list for "Status".

I think that I would need to use the =COUNTIFS formula, but I am struggling to bring in the criteria for not counting tasks with a gray health and a status of "N/A". Any help on this would be greatly appreciated! Thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!