-
Automatically HyperLink URL that's pasted into a form
Hi Smartsheet community. I am trying to figure out how to directly link a URL (pasted into a form !!) to a cell with the exact same hyperlink click-word for that link type. Let me explain the situation better: My company has a sort-of project database spreadsheet to keep track of "leads" or projects that could progress…
-
Automatically updating a super sheet?
I am new to smart sheets and have been tasked with creating a master schedule for our teams. I am working with two different teams on a project and each team has its own schedule. Is there a way that I can set up the team schedules to automatically feed into a super sheet? Ideally, I would like them to identify if an item…
-
URL Responses in Forms
Is it possible to have an end user provide URL link(s) as a response entry in a form for one or more fields within the form, and then have the automation workflow email provide its live URL link(s)? Currently when the end user provides links in a field within the form, the automation workflow email responses come back as…
-
How can I copy hyperlink from a google sheet to smartsheet ?
I am trying to copy a list of rows containing hyperlinked text in one column. When I paste them in smartsheet, links get lost and only the labels are pasted. Is there a way to retain the hyperlink during the paste or any way to separate the url from the hyperlink in Google sheet itself ?
-
How to create a link on a sheet in the row created by a form submission
Form --> Sheet --> DynamicView We use a form to collect some basic information from new staff regarding remote work. The contents of this form are made available to the managers for review and approval of the remote work conditions. We use DynamicView to display the submissions because it is easy to show each manager only…
-
Click on Cell Value to Trigger Search
Leverage Smartsheet's search feature by directly clicking on a cell value. Rather than copy-pasting the value into the search box, I'd like to be able to essentially treat the cell value as a hyperlink that when clicked opens the search results listing all rows with that value. Either via a directly click on the cell value…
-
Click on Cell Value to Trigger Search
Is there a way to leverage Smartsheet's search feature by directly clicking on the cell value? Rather than copy-pasting the value into the search box, I'd like to be able to essentially treat the cell value as a hyperlink that when clicked opens the search results listing all rows with that value.
-
Link an individual task?
I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., attachments, links, and any conversation), it's sometimes really great to send a link…
-
Templates - Hyperlink
I know how to include a hyperlink in a SmartSheet to another SmartSheet. Is there a way to hyperlink a Template in another SmartSheet?
-
Trying to combine two formulas
Hello. I have two working formulas that perform separate functions: =IFERROR(VLOOKUP(A4,$C$4:$E$39 uses the user input to search a partial word, while =HYPERLINK("#"&CELL("address",INDEX($E$4:$E$36,MATCH(E4,$E$4:$E$36,0))),E4) assigns a hyperlink to the search result and takes the user to the data it is associated with. My…
