countIF a value column if the attribute is along side another attribute in a "Multi select Column"
Does anybody know if you can create a formula that will count the values in a “dropdown (Multi-Select) column", when adding summary fields on a Smartsheet list?
What is happening now is, if I have Apple and Orange in one field and I want a count for Apple. it will not count it. Only if I have Apple along in a field?
If I am counting how many time the word apple is in a column I want it to count it if it is alone or if it is along side another selection in that some cell.
Help Article Resources
Check out the Formula Handbook template!