Sign in to join the conversation:
So I've developed several processes that fully rely on query strings for a variety of reasons, and many of my users find it difficult to reverse engineer my sheets to develop similar solutions, even with the official smartsheet help guide. I've made a fairly basic tutorial so I don't have to keep explaining it, and thought it might be useful to some in the community.
My reference:
Official Smartsheet Reference:
@L_123 is is brilliant. Thanks for the detailed work in development and sharing your work.
@L_123 Have you explored using the SUBSTITUTE function to replace all instances of spacial characters automatically?
="url_here?" + SUBSTITUTE(rest of formula for pre-filling, " ", "%20")
There are a few special circumstances that need specific handling such as "=" and "&" as well as if a column is a multi-select that is getting pre-filled. Are we connected on LinkedIn? I have something related to this that you may be interested in.
@L_123 I forgot you had this out here. Take a look at this thread including the link to the published sheet…
I've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
