Smartsheet Guru Blog

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!