COUNTIFS values from multi-select cell and account for date range
Hi - I'm having trouble counting a specific value (text) from a dropdown list and referencing a date range that corresponds to the row. Any suggestions on the right formula to use?
I've played around with the COUNTM, HAS, and CONTAINS formulas but have not been able to achieve what I would like to see. For example, my HAS function reads: =COUNTIFS({TRM Name}, HAS(@cell, "SH-SY5Y"), {Opportunity Start Date}, >=DATE(2023, 1, 1), {Opportunity Start Date}, <=DATE(2023, 12, 31)) where I would like for the returned value to count how many cells in the multi-select "TRM Name" column are have "SH-SY5Y" and the corresponding date range is equal to or greater than 1/1/2023 but less than or equal to 12/31/2023 of the "Opportunity Start Date" column. Sometimes there can be another text item in the field I would like to calculate, such as "SH-SY5Y" and "SK-RC-1" in the same cell.
Answers
-
What is wrong with your posted formula?
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!