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…
In our corporate environment on VPN, we cannot log into the Smartsheet Community Platform/Community Forums because the "Verifying that you are human" step fails. We get stuck on that screen indefinitely and I PROMISE I'm not a robot ;) (wink wink) If you're reading this and it happens to you, do this to get around it: Only…
Please check this video it can help you to position Smartsheet in your company all credits to . Cicero. The video is generated with GoogleNotebook its awesome i think. We explore why thousands of organizations trust Smartsheet to manage work smarter, not harder. 💡 Key Takeaways: Smartsheet goes beyond spreadsheets it…