If bountyhunter tracks many bointies, it's real pain to track stakes/tokens in spreadsheets.
How to track all your stacks in every bounty automatically?
1. Create new google spreadsheet, or use new tab in regular bounty spreadsheet.
For example created free google spreadsheet(link in the end of this post).
I'm choosed one of my first bounties
https://imgur.com/9yGDCS52. Choose your bounty for tracking. In example its XYO bounty.
Find own row in XYO spreadsheet.
https://imgur.com/aM1qhBiTab Facebook, my number 67. Need to copy spreadsheet address (selected with red border on the screenshot) 15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A.
And we prepared 2 code strokes for export.
3. First for the export in your table: IMPORTRANGE("15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A", "Facebook!A1:P1")
https://imgur.com/T4sSU2DThis code export in your table first row from XYO/Facebook spreadsheet
4. Next code stroke with your XYO table number(67):
second row: =IMPORTRANGE("15jG0vRch4BUm0rGIDeAqHZjaPrYgXqtv3LU6t-oVy0A", "Facebook!A67:P67")
This code export in your table your row from XYO/Facebook spreadsheet
https://imgur.com/2wZaqCP5. If you joined in other campaignes (twitter, newsletter, youtube etc) just add rows, change tab names and your number in this tabs.
Now all changes with stakes/tokens you see right in your own table.
Here's a final screen:
https://imgur.com/9yGDCS5Check table here:
https://docs.google.com/spreadsheets/d/1DjlrBqKZPtGIh_pWZA4w_yKMLgRkdd67OVZJpPhm_sQ/edit#gid=0
Show Posts
