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…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
