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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!