-
Can I create a hyperlink by combining text strings and fielded data? Pretty basic parameter work
I have fields: email: subject: body: I want to use this hyperlink to open an email with those parameters: <a href="mailto:myemail@email.com?subject=This is a subject. You can't use certain characters in here. But we should be able to control that.!&body=Here is the body. Same problem with special characters.">Link to send…
-
Saving a folder of sheets with hyperlinks
Hi All, I have a folder full of sheets. Each time my company gets a new client I do a Save As and put all those sheets into that client's workspace. I have a checklist sheet in this folder that has hyperlinks to other sheets in the folder. When I "Save As New" the hyperlinks stay with the blank sheets and not the newly…
-
How to use Countif when the cell is hyperlink to a url
I need to do a count of cell value which is a hyperlink to a url (the cell display a number that refers to the url) e.g. 285555 which links to (http://blahblahbla.com/285555). How do I use COUNTIF for this type of data in the cell? Thanks, Aye
-
How to make multi-select selections be clickable links (in a report or dashboard)
Hi there, Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report or Dashboard. To elaborate, I'd like a Report to have each selected item in a…
-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
Auto-populate multiple cells with hyperlinks to web pages based on the value of one cell?
I have a sheet serving as a software upgrade checklist template "model", (not an actual template, because it contains cross-sheet functionality, which is lost in templates). The sheet includes rows of tasks and a column containing hyperlinks to web-based instructions for each task. Instructions are on different pages based…
-
Hyperlink Formula to Display Text or Image
I have a link being generated based on the information from multiple cells within each row on SS. I would like to have that link embedded into an image, so when a user clicks the image, it takes them to this row specific link. Is SS planning on adding the hyperlinks formula ['=HYPERLINK([cell containing generated link],…
-
missing image links in alert someone automation email
Help, We are receiving these emails in outlook 365 with 3 issues see the screen shot below: This seems to be a link to the smartsheet that triggered the automation. Not having the image display looks poor and I do not want the link to the smartsheet on the email (I noticed that the request an approval automation emails…
-
Update Forms: Can they be created without the automated email link generation?
I have an intake sheet with multiple projects and instead of sending a project manager an automated email with a link to an update form to change any information regarding a project, is there a way to have a form be a standalone link in the intake sheet that when clicked opens up a form in a new tab. From there, the user…
