-
Dynamic formula to update a cell with a URL & Display Text
When I create a URL in a cell, it consists of the URL, and Display Text. How do I write a formula to, say, add the value from the autonumber field onto the end of the URL, and then display the autonumber field text as the Display Text?
-
HTTP 403 Error while copying large attachments from Smartsheet to Azure Blob after 1 minute
Around 4-5 years back we developed a job to take backup of attachments from smartsheet and store it in Azure Blob Storage. We are copying the attachment from Smartsheet to Azure directly using the temporary URL that we receive from Smartsheet GetAttachment API call. We are copying attachments up to a size of 2GB and this…
-
Merged: Customize External URLs
This discussion has been merged.
-
Capability to quickly grab Folder/Sheet Property Info from Workspace Panel
I often have to grab Folder URL when I'm working on projects. (It helps to not grab each reports/sheets URLs when I have lots to reference to several reports/sheets. Since we have so many, I usually try to locate the sheet/report to find out where they exists, then I have to back track where they are in "Browse" mode. If I…
-
Automated hyperlink URL within anchor text
In Smartsheet we are looking to build the following automation: 1. Team A fills out a form with client info 2. After form is entered, an email is sent to Team B 3. Team B logs onto the Sheet, and adds a one-time login URL to the corresponding client row in Column A 4. Team B clicks a checkmark under the "Send Email"…
-
Merged: URL Shortener for Long SmartSheet Links, w/ Custom URLs
This discussion has been merged.
-
Merged: Multiple URLs in the same cell
This discussion has been merged.
-
Merged: Sheet Name URL in DV
This discussion has been merged.
-
Form Submission - Date Help - URL string
Hello all, another form submission question. Have 2 sheets, and those sheets each have a form associated with them. On Sheet 1 Form 1 someone will place all campaign information in this form, one of them being a campaign start date. After form 1 is submitted, a link to form 2 is presented in sheet 1 that takes campaign…
-
URLs in Generated Documents
Hi All, I have created a template for document generation that I can easily use to pull relevant information for monthly reporting. As we are new to SmartSheet, we are still running manual pdf reports to our executives for the foreseeable future. To encourage people to get used to SmartSheet though, we want to have URL…
-
Archive sheets and remove access to URL for users not directly shared to the sheet
I have a few sheets that have been created that I need to archive to only be accessible by a few people who are shared directly to the sheet (sheets are used for reference purposes but don't contain current info which now lives elsewhere). These sheets were previously shared to a larger audience, and a lot of them have…
-
Embedded Dynamic Views in a Dashboard... errors...
Not sure if anyone else has similar experiences but I was trying to build a Dashboard with multiple Dynamic Views embedded into the Dashboard. Using the Web Content Widget, I copied and pasted my DV URL into the field but would continuously receive this error: Any help links within Smartsheet and all Google searches kept…
-
Friendly URL option for forms
Hello. Often tools will offer a friendly URL option. We are using Smartsheet's form feature and sometimes need to share the URL in print. This doesn't work so well with the URLs in their current state. Could we please have a friendly URL option? Many URL-generating tools offer this. Thank you for your consideration.
-
Use a URL shortener service to shorten a URL in a cell
It would be SO amazing to have the ability to choose a cell in my sheet that contains a URL and have Smartsheet create a shortened URL for me. I currently have to leave Smartsheet, navigate to Hootsuite, plug the URL in, click shorten, copy, navigate back to Smartsheet and copy the shortened URL into a cell. I know it…
-
Prefill Contact Field using URL query
Hello, I've tried every trick and formatting option possible to prefill the contact field on a form using the contact field from another sheet. The contact list looks like the screenshot below. The true field name in the sheet of Product Line Manager is PLM I've tried ?PLM=Kevin%20Hietpas%20%28khietpas%40email.com%29…
-
Troubleshooting custom URL queries to populate forms
I am trying to create a URL query to pre-fill part of a form. Here is the base form draft: https://app.smartsheet.com/b/form/6eb502113cf143a0b31bac712ac81336 Here is the customization attempt (only one query for now) which does not seem to work:…
-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
Custom URL Using HTTPS needed for enterprise customers please
Per many interactions with Smartsheet over the topic of Custom URL and why it would not work it was determined finally that https is not supported by Smartsheet. As an enterprise account this is a requirement for us and our IT team. HTTPS method is not currently supported for CNAME we need this to be able to create a…
-
URL query string to prefill default values on a form malfunction. What am I doing wrong?
I'm using a URL query string to prefill default values on a form. When I click the link, it takes me to the form and all of the fields are filled out as expected. However, when I fill out the remainder of the information the form gives me a "invalid or incomplete" error and will not submit. I can submit a blank form with…
-
Hyperlink support in Index/Match/Collect/etc. functions
As other posts for help point out hyperlinks do not transfer when when using functions to look up hyperlink values. Please add support for looking up hyperlink values via formula such that the Display Text and URL transfer to the destination. See details in the links below. The workaround of linking to a cell in another…