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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!