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”))
Ever wanted to make Smartsheet columns in a sheet an equal width? You can easily to this for a couple columns or all...
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...
0 Comments