Count 2 text fields in multi-select options
Hi there -
I'm trying to count if a row has any of of the selections "Briefs" or "All Communications", but not when the row only "Events" or is blank. The report pulls correctly when I choose "Any of" those two in the multi-select, but I want to write a formula in the summary so I can pull it onto a dashboard. I feel like it has to be possible with OR, or another way, but I cannot figure it out. Please help if you know how to write it. Below is the best I have but it's missing some data for "All Communications"
=COUNTIF([Email List]:[Email List], CONTAINS("Briefs", @cell))