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”))
Delivered instantly to your inbox
Consider Smartsheet Guru’s eBook: Smartsheet User Guide for Accelerated Learning
This video gives a demonstration of using the ANCESTORS() and PARENT() functions to reference multiple levels of...
Smartsheet Guru's eBook published! After some months of writing, and working with my producer, Brett Hoffstadt, I have...
Big news! I've just launched the Smartsheet Guru newsletter! In order to promote my newsletter, I'm offering 7...
Join the mailing list and get your copy of my 7 Smartsheet tips!
Join the mailing list and get your tutorial video!
0 Comments