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))
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...
Join the mailing list and get your copy of my 7 Smartsheet tips!
Join the mailing list and get your tutorial video!
Register your interest for the Smartsheet Guru Elite and get our 7 Smartsheet tips!
0 Comments