Smartsheet: Find & Replace in Hidden Columns as Admin

post image

Sometimes, all it takes is a talking out the problem. Or in this case, submitting a Smartsheet Enhancement Request. I wanted to do a Find & Replace All on some text. This isn’t it: but it demonstrates the problem. As an Admin, I can’t Replace All in hidden columns. So I whined and complained andRead more

Smartsheet: Update Multiple Sheets

post image

Updating a Sheet with new functionality takes time. This is true, despite what your supervisor may think. Updating 10 Sheets with the same functionality? More time. This post won’t show how to eliminate all of the time, but it should save some. A Simple Example I have a Project Master Sheet (I avoid using Smartsheet’sRead more

Smartsheet: I hate color (so hide them)

post image

re: “I hate color”. No, not me. And I don’t mean complicated Conditional Formatting Rules like this: although I have thoughts on that too. But I did hear something very close to that sentiment when talking to a customer recently. And like most comments from customers, it got me thinking. (Note to self: That’s why theyRead more

Smartsheet: Transposing Project Schedule

Occasionally, I run across a requirement to show the tasks or dates from a project schedule in a more horizontal view. That is, take something like this: and display (and use) it like this: What is shown is a simple example, only four columns to move over or link to the second Sheet, but I’veRead more

Smartsheet: Using Working Days without Dependencies

post image

Smartsheet allows the concept of working days, and by corollary non-working days (holidays, vacations, my birthday). This setting is on the sheet level, not for individual resources. A SysAdmin can set these working days for all new sheets, but not modify all existing ones at one go. On a sheet, when Project Dependencies are enabled, theseRead more

I’ve been invited to speak at ENGAGE 2017

post image

It is with pride and a sense of gratitude that I announce, that I have been invited to speak at ENGAGE, Smartsheet’s first user conference September 2017. I hope to see you there, to meet people I only know by e-mail and the Community, or customers I only know from tele-conferences. Here’s the link to theRead more

Smartsheet: Quick Backup

Today, I realized I had about two dozen sheets I wanted to remove from Smartsheet. Being me, I didn’t / couldn’t just hit the “delete” key, but the thought of converting them to Templates or exporting them one by one had my finger hovering over that key, slightly trembling (I exaggerate, but not by much).Read more

Zapier: Explore Specific Apps Faster

post image

If you use Zapier for SaaS integration (there are good reasons to do so) and, like me, you occasionally need to check out a new integration, refresh the possibilities of ones you already use, or check out recent changes, it may help you to know about some short-cuts I use. Explore page The first isRead more

Quick Tip: Help with Help (Smartsheet Formulas)

The Background If you are reading this, you probably have already read the manual, that is, the Smartsheet‘s  Help articles on formulas. I keep this link book-marked: https://help.smartsheet.com/articles/775363-using-formulas I also use Wachete to monitor for changes. You can also access the help from within a Smartsheet using the Function icon This icon is also a convenient wayRead more

An Alternative to Nested IF’s

post image

An Alternative to Nested IF’s Warning: It takes longer to explain the problem than it does to explain the solution. One of the common issues raised on the Smartsheet Community is problems dealing with NESTED IF’s. NESTED IF are a series of IF statements that are chained (nested) together. These are allowed and occur becauseRead more