CountifS based on a multi select column

=COUNTIFS({CTC Business Sales Specifics}, FIND("Contract Renewal", {CTC Business Sales Specifics}), {CTC Business Sales Sold Month}, Month@row)

Basically, trying to calculate a count from another sheet.

If sale specifics has "Contract Renewal" in it, I want a value. The rest based on the month works fine, but I can't get it to count if it contains "contract renewal.

I'm unsure if CONTAINS would be a better formula?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!