Welcome to Ronin Global

Learn More

Welcome to Bazaar Lite

Get Now

Welcome to Bazaar Lite

Get Now

Passing the Torch

Sports Sometimes, change is bitter sweet. I am not a sports fan. I might need to take my shoes off to count all of the current American Football, Baseball, Hockey, or Basketball stars’ names I know, let alone their teammates. Some of those might not play anymore. Usually I can’t tell you who won lastRead more

Smartsheet Tip: Chart Changes

post image

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

The Journal

post image

I use a lot of different software. Lots. I know I am not alone. This isn’t braggadocious1, I’m just setting up background. I’m not writing about the ones that are “just there” — anti-virus, online storage sync programs, and the rest that just sit in the system tray and are actively ignored. I mean theRead more

So, this happened last night…

post image

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

Smartsheet: Bulleted Lists

post image

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

Smartsheet Enhancement Request: BRANCH

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

Smartsheet: Sort by Parent (Ignore Children)

post image

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

Smartsheet Enhancement Requests for Templates

post image

This post is different than my normal Smartsheet related posts. I’m going to try to put down my current thoughts on Smartsheet’s Templates and what’s missing for me. This post can not be all-inclusive, but I hope it helps me consolidate some of things that have been rattling around in my head for a while.Read more

Smartsheet Tip: Release items from memory (Chrome)

post image

This tip refers to Smartsheet, Google Chrome, and Windows (I’m on Win 10 as I write this) I found this tip recently as I was trying to figure out which Chrome tabs, of the many  I had open, were causing my work (which I often do on the Internet) to slow down. I tend toRead more

Defaulting to A Date in a Smartsheet WebForm

post image

Smartsheet‘s Forms allow a date to be selected when building the Form. Unfortunately, that [Today] button only selects today’s date, not setting the default to whatever date the form is used. This has never really been a major problem for me. Once the form is submitted, I captured the row’s creation date, in effect capturing “today”. BasedRead more