Smartsheet Tips – SmarterBusinessProcesses

Tip: Using Conditional Formatting and Formulas Together

GwenR — Thu, 16 Apr 2015 10:52:03 +0000

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.

The post Tip: Using Conditional Formatting and Formulas Together appeared first on SmarterBusinessProcesses.

Smartsheet Tips: Displaying Parent Rows in Reports

GwenR — Thu, 22 Jan 2015 22:49:19 +0000

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.

The post Smartsheet Tips: Displaying Parent Rows in Reports appeared first on SmarterBusinessProcesses.

Smartsheet Tips: Working Offline

GwenR — Wed, 03 Dec 2014 16:12:57 +0000

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

The post Smartsheet Tips: Working Offline appeared first on SmarterBusinessProcesses.