Smartsheet Tips
Tip: Using Conditional Formatting and Formulas Together
Conditional formatting works great if you're looking to highlight rows based on data or values already contained in the sheet (e.g. a red background colour can appear on rows when the "status" is "overdue"). Issues can arise when you want to apply the formatting based on a comparison between two cells in the sheet. For example, if you have a "target cost" column and an "actual cost" column, and want to apply a red background colour to rows that exceed the estimate. This can't be done with conditional formatting rules alone.
That’s why we recommend using conditional formatting's greatest ally - formulas! Specifically, you will want to use an IF formula to perform the comparison between the two values, and then apply the formatting rule based on the result of the formula.
Smartsheet Tips: Displaying Parent Rows in Reports
In real life, parents are the ultimate project managers. It’s up to them to make sure that everyone is organized and on the same page, and that all tasks, from chores to getting to soccer practice, are completed in a timely manner.
In the world of Smartsheet, we, too, have parents that maintain organization and structure. Well, okay, they’re not actual parents, but they are called “parent rows”, and they function very similarly.
Smartsheet Tips: Working Offline
There are so many benefits of Smartsheet being a cloud-based app: You can access your files from anywhere, you don’t have to worry about version control issues, and it doesn’t matter what platform you’re using.
But sometimes, you’re offline and you still need to get some work done









