Smartsheet Tips from Support – SmarterBusinessProcesses

New in Smartsheet: See Images in Your Sheets

GwenR — Thu, 21 Jan 2016 16:38:10 +0000

We’re excited to announce our newest feature: inserting images directly into Smartsheet cells. Viewing images in the grid (instead of clicking to open multiple attachments) provides instant context surrounding a project, as well as a time-saving method of feedback and direction. Here’s how it works:

The post New in Smartsheet: See Images in Your Sheets appeared first on 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.

Tips from Support: 4 Ways for SysAdmins to Manage Their Accounts

GwenR — Thu, 05 Mar 2015 16:27:21 +0000

What happens when a licensed Smartsheet user leaves the company? How do you transfer owned sheets to another person or remove the user altogether? How do you add non-licensed users to your Team account?

The post Tips from Support: 4 Ways for SysAdmins to Manage Their Accounts appeared first on SmarterBusinessProcesses.