Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Capture URL via Join data from one sheet to another
I Have two sheets, one is a list of tickets and the second is a Rollup sheet summarized by project. In the ticket sheet each ticket has a project name that I use to relate back to the Rollup sheet. I have created a function that reads all tickets by project name and then joins the ticket numbers to be stored on a project in the rollup sheet. The ticket numbers are actually links.
How can I bring in as links instead of text? Attached a screenshots, below is the Join function I'm using.
=JOIN(COLLECT({Jira Rollup - Action Tickets Range 5}, {Jira Rollup - Action Tickets Range 1}, =[Project Name]@row, {Jira Rollup - Action Tickets Range 2}, <>"Closed", {Jira Rollup - Action Tickets Range 2}, <>"Solution Provided", {Jira Rollup - Action Tickets Range 2}, <>"ER Rejected", {Jira Rollup - Action Tickets Range 2}, <>"Feature Released", {Jira Rollup - Action Tickets Range 2}, <>"Duplicate", {Jira Rollup - Action Tickets Range 3}, CONTAINS("implementation-risk", @cell), {Jira Rollup - Action Tickets Range 4}, <TODAY(-3)), ", ")
Ideally I'd like to bring in the Display text as a link but would be happy if I could at least bring in the URL link.
Answers
-
This is what my results currently look like. I need links not text. Is there a way to do this
-
I hope you're well and safe!
It doesn't work with the Hyperlink option; you'd have to add the URL as ordinary text.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andree, As you suggested, I had t add the full URL.
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
