Smartsheet Count Occurrence of Contact In a Multi Contact Column
Channel: Smartsheet Guru
Date: 2021-08-11

This video shows you how to count the occurrence of a specific contact in a multi contact column.  This example shows how tasks John Smith, Joe Smith, and Smartsheet Guru are assigned to.  


Forumula used is: 
=COUNTIF([Person's Assigned]:[Person's Assigned], HAS(@cell, "John Smith"))

My eBook: Smartsheet User Guide for Accelerated Learning 👉 https://amzn.to/3i7jVPH (paid link)
Get my 7 Smartsheet Tips👉 https://www.smartsheetguru.com/7-smartsheet-tips/
❗I apologize, the audio in this video is pretty embarrassing.  See what I use to record now: https://smartsheetguru.com/mic 

https://www.smartsheetguru.com/2021/08/21/smartsheet-count-occurrence-of-contact-in-a-multi-contact-column/
https://www.smartsheetguru.com
Also on Odysee: https://odysee.com/@smartsheetguru:1
#smartsheet #smartsheetcoaching #smartsheettutorial #howtousesmartsheet #coaching