Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Google Sheets: Can't edit fetched data.

Jonathan Katz
Jonathan Katz December 3, 2019

The data I fetch from JIRA Cloud disappears if a change the data locally (from within google sheet) in any cell. Also, when I try to add individual cells (=a1+a2) it works but if I do a formula (=sum(a1:a2) it always comes back with a 0.

 

Answer
Watch
Like Minh Tran likes this
271 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 4, 2019

You'll need to fix that in your google sheet.  It is not a Jira problem from what you've said here.

View More Comments
Jonathan Katz
Jonathan Katz December 4, 2019

I figured out at least a portion that was instead of using =sum() I had to switch to =sumproduct()

but thank you 

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events