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
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
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
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
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
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
Despite (or because of) being active on the Smartsheet Community (when I have time), occasionally I get emails to one of the several emails I have added to my profile there. Here’s one I got recently. Hi Craig, Can you please help me figure out a formula for this situation: I have a ‘Start Date’ columnRead more
I went to bed angry last night. There’s not anyone else in the house, so that’s OK. I guess. I woke up annoyed, but I have work to do so did not think I’d set aside time to write anything more than that in my journal. Then I read this excellent post on personal ethics on myRead more
The Gig I’m looking for Pro Bono work this summer. Preferably management, Smartsheet usage, but I’m flexible. A few details Certified non-profit organization And I don’t mean a company that doesn’t make a profit, but a charitable organization. I also don’t mean a company formed to benefit another company or set of companies. I meanRead more
Recent Comments