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 solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group. Solution overview Python Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.…
