-
Hyperlink to corresponding row in external document
I have a 600 row Smartsheet and need to provide hyperlinks for each row to an external Excel document. At the moment, a basic hyperlink will open Excel but place the cursor at the top of the sheet. Can I create a hyperlink formula to match the reference numbers on each row? Link for Reference 010 opens Excel document with…
-
Include Hyperlink in Formula where I'm pulling through the parent task?
Hello! Im my sheet I have a formula in a helper column to pull the value of the parent task into each row - our parent task is our project deliverable name and it helps to have that in line for other views / reports. In our parent tasks, we are hyperlinking to our project brief. However, that hyperlink does not pull…
-
Hyperlinks / Update Requests
Hello, I currently have a workflow in place with a update request being send out with helpful hyperlinks with instructions for my users to view prior to checking off and item as complete. The issue is the hyperlink only works within outlook, the hyperlink functionally goes away when the user clicks on "open update request"…
-
Copy Sheet Name Hyperlinks to Another Sheet
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
-
Phone Numbers and Street Addresses turn to Blue Font but only on Phone App
Hello, We have an interesting issue where all the phone numbers and street addresses we enter in a given row turn to blue font, but ONLY if viewing on the phone app. No matter what we do, we cannot figure out how to override this. It's an issue because a large majority of our conditional formatting relies on the use of…
-
Collapse Hyperlinking Search Box
When you insert a hyperlink to a Smartsheet Item, and click <select sheet>, the menu defaults to all workspaces and folders expanded. Although you can use the search box at the top to filter the list down, it is still cumbersome if you are trying to link to a sheet with a common name like "Issue Log" or "Project Plan". I…
-
Create hyperlinks from values of a dropdown list column in Smartsheet
It would be good if you could create hyperlinks from values of a dropdown list column in Smartsheet. Specifically, if you could create multiple hyperlinks from multiple values of a dropdown list within a single cell. That way you can click on the multiple selected values within the same cell and link to multiple different…
-
Valid link?
We use forms to get (literally pull teeth) about their 3D printing requests. It would be nice if we could verify a link indeed a link..
-
Form link field validation
Hello, Is there a way to add validation to a hyperlink field on a FORM? I could run a check after submittal, but that is more effort than it is worth. Double Dipping here: I was reading an article on the best online forms. They recommended the error notification be immediate. I have many students baffled by what is wrong…
-
can you build a formula to separate longitude and latitude after it was hyperlinked
So I have a sheet where the GPS coordinates are hyperlinked into a column with the use of a form. I would also like to have the longitude and latitude separated into their own columns for exporting to excel reasons. Is there a way to build a formula to separate the longitude and latitude that is being uploaded as a…