by darren | Dec 19, 2022 | Announcements, Smartsheet Tricks
Smartsheet Guru’s eBook published! After some months of writing, and working with my producer, Brett Hoffstadt, I have completed my first eBook! It is titled, Smartsheet User Guide for Accelerated Learning: Powerful Tips to Jump-Start Your Smartsheet Training....
by darren | Sep 8, 2022 | Announcements, Smartsheet Tricks
Big news! I’ve just launched the Smartsheet Guru newsletter! In order to promote my newsletter, I’m offering 7 Smartsheet tips that I think you’ll find useful. No matter your skill level in Smartsheet, I believe you will find something useful. How do...
by darren | Aug 31, 2022 | Smartsheet Tricks
In this video, I’m showing how to use the Smartsheet @cell operator to create more efficient formulas and reduce the number of columns that you need to...
by darren | Aug 3, 2022 | Smartsheet Tricks
Looking for a way to create more consistent Smartsheet projects, but aren’t ready to invest in Smartsheet Control Center? You can emulate a lot of Control Center features using a manual method until you are ready to dive in to Control Center for all of...
by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks
I ran into an issue with Tableau bringing in data properly from Smartsheet when I had a combination of numeric and alphanumeric values in one of my Smartsheet columns. In order to ensure that Tableau recognized all the values as the same data type of string, I created...
by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks
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 {}...
