You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have 4 to 5 Master Google sheets that I used to export data from Jira via filters every hour. I then have probably 20 to 30 different worksheets that use this data from my master spreadsheets. On occasion, I find that the connection from JIRA to google sheets gets disabled and it’s only when I stumble across the data being stale that I have to reconnect.
I have tried to find a function within google sheets that can record a date timestamp of the last import but to no avail. I’m curious if there’s any notification service that exist today that could notify the user if the connection fails