Google Sheets: Can't edit fetched data.

[Jonathan Katz]

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.

[Nic Brough -Adaptavist-]

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

[Jonathan Katz]

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

but thank you