Count If formula for multiple items within 1 cell

Hello all,

I am trying to generate a report from a Smartsheet (that is auto-populated from a form) that will give me a total count of how many people have access to which event space, per day requested. Since each cell could have 1 or multiple values, right now my CountIf formula is only correctly calculating the cells that have a single value ex. It says there is only (1) 18th Green Marquee request, instead of (3). I have not gotten into the weeds with the date criteria yet since I was trying to determine if the first part was possible.

Thank you in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!