Thanks for your informative videos. How can I contact you to see if we can work together on a couple of Smartsheet projects I am trying to put together? Also, why not use the "IF" function to go and find something and return the value on the second sheet? I suppose the JOIN function can return values in multiple columns, versus doing an IF formula individually, right? Look forward to speaking with you.
Sol, thanks for the kind words. Sorry for the later response, just got back from a short road trip. Reach out to me using my Contact Page: www.smartsheetguru.com/contact/ As far as using an if statement, that doesn't work over a range, which is the purpose of the collection function as well as the ability to have multiple criteria. Looking forward to hearing from you!
Thanks for your informative videos. How can I contact you to see if we can work together on a couple of Smartsheet projects I am trying to put together? Also, why not use the "IF" function to go and find something and return the value on the second sheet? I suppose the JOIN function can return values in multiple columns, versus doing an IF formula individually, right? Look forward to speaking with you.
Sol, thanks for the kind words. Sorry for the later response, just got back from a short road trip.
Reach out to me using my Contact Page: www.smartsheetguru.com/contact/
As far as using an if statement, that doesn't work over a range, which is the purpose of the collection function as well as the ability to have multiple criteria.
Looking forward to hearing from you!