-
bulk update individual cell references at the same time.
I have a scorecard that pulls data from several other spreadsheets, all of which are specific to different years. With the new year approaching, I aim to generate new copies retaining the same workflow and linked sheets. Is there a method to duplicate all sheets with new year specific names while maintaining the existing…
-
Can Bridge add the "Row Link" to Cells?
My users maintain inventories which interrelate to each others' rows. They administer all new rows by inserting the Row Link into the Primary Column cell's text as a hyperlink (<link url=Row Link>text</link>) so that, wherever the row is index matched into another sheet, the user can navigate across sheets to view the…
-
Easy access to navigation/location info
I'd like to propose that the object path be available right under the name of the object (top-middle). For example if I have a sheet that is in multiple sub folders, I know I can access its location by clicking on File > Properties. Then I can click on the hyperlinks for workspaces/folders. BUT to reduce the amount of…
-
Row Link - Can it be extracted or used in an Alert or Form?
My users are getting a little lost when they are sent to a sheet via an Alert or Update Request. It would help if there was a way to point them to the correct row. I know you can get to the specific row via selecting the row, right clicking and selecting "Properties", then looking under Row Link, and the URL/hyperlink…
-
Sending Request Form with Hyperlink
Hi, I want to know If there is a hyperlink in my sheet, which points to another smartsheet. I use workflow to ask others to update their row. In this case, I found that after receiving it, they could not click on the hyperlink to go to another smartsheet. In that cell, it was only displayed in text format. I want to know…
-
Formula to check whether or not a cell has been hyperlinked
I am trying to create a helper column that checks whether a cell in a nearby column ("Project" in this case) has been hyperlinked or not. I want to return 1 if True or 0 if False. Something like this: =IF(CONTAINS("http", Project@row), 1, 0) However, when I hyperlink using the menu dropdown (see attached image), this…
-
Merged: Open link in new tab
This discussion has been merged.
-
Question around Workflows and URLs
Hi Community, I need your help on a (possibly) simple issue I am facing. I have a very basic report with a very basic workflow. When a specific criteria is met, the workflow sends an e-mail with all the row details, including a link to a customer. Let's say that column is "Account Link" The issues come with the automated…
-
Smartsheet Form Hyperlinks opening in a new tab
Ability for hyperlinks to open in a new tab in Smartsheet forms so entered information is not cleared. If the hyperlink is not in the form description section (embedded in a field help text) it will clear out all of the information in the form.
-
Dashboard enhancement: drop down menus
Another request to recapture dashboard screen real estate. I would like to see a drop down widget that expands to show: added context/information hyperlinks Screen real estate is important on dashboards, so I hate taking up space with the links widget. Having a drop down with all the links would be a-maz-ing. If it could…