This video shows a simple example of how to pull in a value from one sheet into another using more than one criterion. The collect function can collect values based on multiple criteria, then the join function displays it as a text value.
Formula used (The value in {} is an off sheet reference:
=JOIN(COLLECT({Source sheet Name}, {Source sheet Project}, Project@row, {Source sheet Department}, Department@row))
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