Count Ifs Specific Year


I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024.

=COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 2024)

this is what i have (primary column is referencing the word bidding).

I am pretty sure it has something to do with the date portion, maybe because there is TBD in the column as well.

Source Sheet

Sheet with Calculations

Help much appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!