Smartsheet Guru Blog
Set Equal Smartsheet Column Widths
Ever wanted to make Smartsheet columns in a sheet an equal width? You can easily to this for a couple columns or all columns in the sheet. All you have to do is select the columns you want to equalize the width then change the width of one of the columns and all...
Smartsheet Sponsored McLaren F1 Lego Race Car
Mommy, Daddy, what's Smartsheet? Can you imagine hearing this question as you're sitting around the Christmas tree? Probably not, but it may be a question coming to many parents. Lego has a McLaren F1 Race Car set with the Smartsheet sponsorship displayed on the front...
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
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...