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…
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
