Count Ifs Specific Year

Options

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!