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
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!