-
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…
-
Allow notification hyperlinks to be opened in new tab/window
Please allow hyperlinks in the notifications sidebar to be opened in a new tab/window, same as any standard hyperlink. (Middle click / Ctrl+click / right-click>Open in New Tab / plugin mouse gesture) I see there is a similar request for hyperlinks in forms to be handled in this same fashion, or perhaps to allow the form…
-
Dynamic View: Hyperlinks
We currently build a hyperlink to a prefilled form using a formula and the row ID. But the biggest limitation on this is they do not function in Dynamic View. The end user has to copy/past to get to the form.
-
Pasting hyperlinked text between smartsheets
I am trying to copy and paste hyperlinked text between smartsheets. All I am able to do is paste the text and not the hyperlink that was attached to the text. I have tried pasting special and that has not worked either. Thanks for any advice you may have!
-
Auto-populate a form field with the result of a formula in the sheet.
I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe I…
