Count If formula for multiple items within 1 cell
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!
Help Article Resources
Check out the Formula Handbook template!