-
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…
-
Automatic Duration column calculation + Linked Dates, is this possible?
Is it possible to have a "Duration" column that automatically calculates duration days based on End Dates that are linked to another sheet? For context these are my 2 scenarios: One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.…
-
Create a Form with Auto Filled
I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department. Is there a way to create a form within Sheet 2, use the…