Smartsheet Blog

The Best and Worst Days for Productivity

Best and Worst Days for Productivity
There’s a good and bad day for just about everything. If you’re looking for a job, the best day to apply is Monday. If you want your customers to open your emails, send them on Tuesday. If you want to hold an efficient meeting, Tuesday is also the winner. But, what is the best day for you (or your team) to be productive? When is the optimal time to start a new project? And when should you invite colleagues to collaborate on your project? We’ve got all these answers and more to help you maximize productivity during the week. At Smartsheet, we look at a lot of anonymous app data to gain insights about the way we work.
Read more
Tip from Support - Conditional Formatting with Smartsheet
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!
Read more

4 Best Practices for Gathering Creative Feedback

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.
Read more

3 Ways to Use Smartsheet Merge

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.
Read more

Life by Email: An Interview with Author Phil Simon

Phil Simon Interview
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.
Read more