Thoughts on Work-Around’s Posted on This Site

The work-around’s that I develop for software I use (like Smartsheet) fall into several categories. These are subjective, my opinion, and can change over time or further development in the existing software or the third party tools employed. At Risk: The solution could be replaced by a modification to the software that seems to line upRead more

Smartsheet: A Different (Maybe Even Better) Send Row

post image

Anyone that uses Smartsheet should probably know that the user can send a row with a few clicks of the mouse and some typing. This will send the chosen user(s) an e-mail copy of the row(s). The e-mail provides a convenient link back to the sheet that contains the row. Unlike some of Smartsheet’s otherRead more

Forcing TODAY() refresh in Smartsheet

Because Smartsheet and other spreadsheets lend themselves to being used as task lists, a common request on the Smartsheet Community is how to “create recurring tasks in Smartsheet”. While on the surface, this seems to be a simple question, it isn’t. The answer isn’t simple either. We aren’t going to cover that bigger question here. OneRead more

Never say never: There might be a way

One of the things I enjoy about reading and answering questions on the Smartsheet Community forum is that every once in a while there is general consensus that something can’t be done. Some of these are like brain teasers to me. I think about them for a while, I mull them over, I come backRead more

Smartsheet: Stop Alerting me! The task is complete!

post image

UPDATE 2017-03-23: Smartsheet release yesterday (2017-03-22) may have made this work-around moo. I hope so, but won’t know for sure until I have updated a bunch of sheets. If you find something that still requires this work-around, let me know. Smartsheet has two types of Alerts: Notifications and Reminders. A common request is how toRead more

This Is Not a Conversation

I was going to work today. Locally in my house, without social media pulling me away. And then I got a response to attempts to voice opinions to my senators. I had a follow up question, but so much for that idea. What was I thinking? I get that I submitted a form and theRead more

The Simple Big Lie

post image

Adolph Hitler said: “If you tell a big enough lie and tell it frequently enough, it will be believed.” He actually said a lot of things, and one piece of advice from me is that a quick search of the Internet for “best Hitler quotes” may turn up some phrases that have loud echoes inRead more

A Bad Day of Development – A Stream of Consciousness Journey

Well, not stream of consciousness, more like stream of Internet surfing. I’ve been working on the business case and business model for an App I’m building and testing. That part is going well, thanks for asking. For some reason, I woke up annoyed at SaaS deployments. Seriously annoyed. I rarely remember my dreams, in wholeRead more

Smartsheet: Referencing a cell that doesn’t exist yet

When I saw the post on the Smartsheet Community, I didn’t think there was an answer. The question (paraphrased) was: How do I reference a cell that does not exist yet? The use case is a sheet is populated via a WebForm and adds new rows to the sheet at the top. A certain columnRead more

Smartsheet: Fixed date upon completion

post image

One of the FAQ’s in the Smartsheet Community is a asking for a way to have a “Completion Date” cell be updated automatically when a user sets a status to ‘completed’, a percent complete to 100%, checking a “Done” checkbox, or dozens of other ways a task can be marked as finished. For example, a userRead more