Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,551,886
Community Members
 
Community Events
184
Community Groups

Jira Cloud to excel no longer linking to key - formatting looks like links

Rachel Young
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 27, 2023

Hello! 

When I first imported my jira project into an excel sheet, the Key column was linking directly to each issue in Jira. However, now there are no links in the document. Additionally, all 3 columns A, B and C are formatting to look like links (blue text, underlined), but are not links. Is there a way to at least have all the text look the same? 

I didn't change anything with the sheet and have reimported the project and am still getting the same results. 

Screenshot 2023-04-27 095911.png

1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 29, 2023

Hi Rachel - Welcome to the Atlassian Community!

It might just be with your Excel setup. I am not an expert on that at all so you would need to do some Googling. But if you right click on one of the values in the Key column, you should be able to select Edit Hyperlink (or maybe even Open Hyperlink). If you do the Edit Hyperlink, see what value is in the Address field. If there is a value there, you just need to click on OK and it should make it a link in your sheet. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events