This is a public service announcement for anyone who uses or intends to use JTOPMERET.If you don’t know what that is, then this article is not for you. TL;DRFor TOPMERET delivered with JADE 5.3.0, if you have existing models built with TOPMERET and wish to add a new model or update an existing one withRead more
… but I am probably acting petulant. My excuse is that is 6am, I’ve been up for two hours because my brain won’t shut up about the incredible1 things happening at work in the past few weeks. Someone read2 one of my posts and found a broken link. They were nice enough to point out theRead more
Imagine if you will: I walk onto a used car lot and … while I’m standing there looking at a car that interests me, a salesman slides up to me. “This car looks interesting to me. How much is it?” I ask. The salesman smiles and says “How much do you have?” I land onRead more
While reviewing a set of metrics that I had been given, I mentally checked them off 1 one by one. At the end of the list, there was this word = etc.2, short for the Latin phrase et cetera. This is something that I watch out for. ref – Oxford Living Dictionaries 3 Etceteras 4 can be usedRead more
The Gist At ENGAGE 2018, Smartsheet released a feature that has been long requested and much demanded on the Community Posts and I assume elsewhere. Assigning Multiple People to a Task I won’t go into my opinions on it1. There is no time to waste. Really. It is here and what should you do aboutRead more
Introduction This post started out as just personal documentation so I could recall later how I had done something. It kind of grew a bit from there. Backstory: Recurring Widget Tasks One of the task types I sometimes want/need to track is what I sometimes referring to as ‘recurring widgets’. This type of tasks mayRead more
What to expect here: While I discuss Smartsheet , this isn’t a post about Smartsheet. It is about me and includes: An example of one of my ‘customer types’ An example of a problem, the solution, and the journey and This is part of a series of posts 1, discussions with friends and family, andRead more
Today’s Tip (2018-08-22): Based on this Community Post Smartsheet does not have a rich text field and the user requested bullets. Here’s a quick way to get the result. I wouldn’t use this very often, but I don’t need to use all of my work-arounds, though it helps. I set up a secondRead more
I would like to add a Hierarchy based function: BRANCH. That is, starting from a many tiered hierarchy and pulling out information needed, easily. I think I may have a work-around for this lack-of-feature, but I suspect it is prone to breaking by the end-user. It is also not fully tested and adds unnecessary* burden onRead more
Today’s Tip (2018-08-03): Based on this Community Post. The user wanted to sort a hierarchy, but only on the Parent Row. Here’s how: I created a column named [Sort Order]. I added this formula: =IF(COUNT(ANCESTORS()) = 0, [Primary Column]@row, COUNT(ANCESTORS())) to each cell. It checks if this is a Parent Row (COUNT(ANCESTORS()) = 0) andRead more
Recent Comments