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
-
Yes, CONTAINS would be the way to go. Since you're already specifying the range, give it the criteria of CONTAINS(value, @cell).
=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Yes, CONTAINS would be the way to go. Since you're already specifying the range, give it the criteria of CONTAINS(value, @cell).
=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
THANK YOU! - I was trying to reference the same {CTC Business Sale Specifics} VS the "@cell".
-
@Mtmoroni Happy I could help!
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
This formula has been very useful for the data sheet that I am creating and have a follow-up question.
Use the same example formula, how would you amend the formula to include any values to count where historically "Contract Renewal" was titled as something else. Say "Account Renewal" or "Renewal"?
=COUNTIFS({CTC Business Sales Specifics}, CONTAINS("Contract Renewal", @cell), {CTC Business Sales Sold Month}, Month@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!