Smartsheet Guru Blog

Smartsheet Book: Smartsheet Architecture Solutions

Smartsheet Book: Smartsheet Architecture Solutions

I have just released a video showing some details about my forthcoming book: Smartsheet Architecture Solutions. Read more at smartsheetbook.com or take a look at the video below: https://youtu.be/jbvu7PQCxRU

Smartsheet Dropdown List from Another Sheet

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!

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 Mugs

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

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...

Subscribe To the Smartsheet Guru newsletter

Join the mailing list and get your copy of my 7 Smartsheet tips!

You have Successfully Subscribed!

Get your Smartsheet Lead Tracker app tutorial

Join the mailing list and get your tutorial video!

You have Successfully Subscribed!