Smartsheet Guru Blog
Smartsheet Dropdown List from Another Sheet
Ever wanted to update the values of a Smartsheet dropdown list from another sheet? How about automatically updating a Smartsheet contact list or Smartsheet dropdown list from another sheet? Smartsheet doesn't offer this functionality out of the box, but there is a...
Parents, Ancestors and Smartsheet, Oh My!
This video gives a demonstration of using the ANCESTORS() and PARENT() functions to reference multiple levels of hierarchy. As promised in the video, here are the formulas: Level column formula: =COUNT(ANCESTORS()) + 1 Project - Task Group column formula:...
Smartsheet User Guide for Accelerated Learning
Powerful Tips to Jump-Start Your Smartsheet Training
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. This...
Smartsheet Mugs
Are you or your co-workers Smartsheet aficionados? If so, I've designed some mugs for you to get you through those complex formulas! (Affiliate links below). My personal favorite - The Nested If Statement Guru! Smartsheet Mug - Nested If Statement Guru Or, if you are...
7 Smartsheet Tips from Smartsheet Guru
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 you get my 7...
Using the Smartsheet @cell Operator for More Efficient Formulas
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 create. https://youtu.be/KchiWBgsv4A