Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Favorite Smartsheet formatting tricks!

Adam S
Adam S
edited 12/09/19 in Archived 2015 Posts

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
    John Sauber ✭✭✭✭✭✭
    edited 07/27/15

    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.









  • Rae
    Rae ✭✭✭

    When you click on the link for the formatting tricks, it no longer takes you to that page.  Where should we be searching for this content at this point?


This discussion has been closed.