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 color 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 color 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!
You can learn a lot from your customers. Everything from day-to-day work challenges to which features are most useful for getting things done. Our customers help influence our product roadmap and often are the driving force for many of our evolving product features (most recently, our upcoming addition of duration in hours and critical path). And last month, during one of our Smartsheet Academy training sessions, we asked our customers to give us feedback on a slightly different topic: our branding. We wanted to know what they thought of our name, our homepage, our brand identity, and other marketing initiatives.
Say goodbye to copying and pasting -- there’s a new way to move data. Now, with just a couple clicks, you can create hundreds of docs, instantly. Smartsheet Merge allows you to quickly create Google documents in seconds with information stored in Smartsheet. You can use Smartsheet to collect and track lists, names, addresses, and other information, then use Merge to automatically push that data into a custom Google Doc template. Smartsheet Merge quickly creates personalized invoices, form letters, or envelopes, saving you hours in administrative work. You can seamlessly combine multiple documents into one for easy printing or create docs and PDFs to share directly via email.
In the time it took you to read this sentence, 20 million emails were written. There’s no question we all receive too much email (over 100 billion emails are sent and received each day). But, no matter how many times we complain about time wasted over email or the sheer amount of messages in our inbox, the truth is, we actually like it. And science can prove it. We get a rush of dopamine to the brain’s pleasure centers every time a new email comes in. Researchers believe that our compulsion to constantly check email is driven by the dopamine releases that occur in anticipation of receiving good news. Along the sames lines, our sense of value gets inflated the more emails we receive.
2015 is the year of work visualization, combining people, work, and content in a visual framework to uncover valuable insights about the patterns of collaboration. At Smartsheet, we’ve been working to give our users more ways to picture their work, with new features like enhanced symbols, and integrations with Tableau and Office Timeline to turn data into simplified, beautiful visuals. The analyst firm GigaOM also recently published a report exploring the future of work visualization, and we released our own piece on its importance. We feel strongly about visualization and its power to offer a never-before-seen-view of who is doing what and with whom.
Get Our Best via Email
Sign up to get our most popular articles delivered to your inbox every two weeks.