How can I use a formula to count the total in a column that has specific values

I am try to count the number of people who are internal coming to an event, so we have a form that people put in what their organization is. If it is internal, it should have Geisinger in the name, but there are many branches, so it could be Geisinger (insert campus names). I want to calculate how many people have Geisinger in the name of their organization without having to ask them if they're internal or external.

This is the formula I have so far-

=COUNTIF(CONTAINS("Geisinger", Organization:Organization), "True")

I keep getting an error. Any ideas?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!