Counting Formula Help

edited 03/18/24 in Formulas and Functions


I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Attendances by Person 1 + Attendances by Person 2 which gives me a result of 6 however, since they are from the same department, the result needs to reflect 5 since the department attended 5 times. Attendees is a multi contact column.

Thank you so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!