Favorite Smartsheet formatting tricks!

Adam S

One of my favorite formatting tricks is the disapearing checkbox.  This trick allows your header rows to look clean (without blank checkboxes).  Check it out: https://www.smartsheet.com/blog/support-tip-formatting-tricks

 

What's your favorite formatting trick?

John Sauber

Excellent topic, Adam. I hadn't seen some of those tricks in the link, so I'm glad you shared.

 

The disappearing checkbox is a great trick!

 

Here is a recent discussion on making reports have the appearance of conditional formatting of their own.

 

Another thing we like to do, is create a checkbox column called Is Parent?. The formula is =IF(COUNT(CHILDREN(Task1)) > 0, 1, 0), and this checks a box if the row is a parent, and then we can conditionally format based right on this column, and the column name makes it super easy to read in the conditional formatting menu. We like easy to read . We can apply header formatting to all parent rows in one shot. This column would typically be hidden.