Thanks for the share man, I have tired and tired to implement it as you said but keep getting error message, I guess I will need to spend more time to understand it or do a bit Google research to know how to implement it. this will really save me a whole of stress and data. thanks again
check if you have any spaces - it's a main reason for error message, try to copy my code and just replace table part and numbers 
Topic: Stakes/tokens autotracking (Read 119 times)
Thanks for the share man, I have tired and tired to implement it as you said but keep getting error message, I guess I will need to spend more time to understand it or do a bit Google research to know how to implement it. this will really save me a whole of stress and data. thanks again
Thank you, useful information! It is a pity that it is impossible to automate...
thanks man)
Thank you, useful information! It is a pity that it is impossible to automate...
Thanks for information, it really helps a lot to us specially if we joined a lot of social media campaigns. But I guess it does not applied to the user who used in android phone only like me. Well, I will mark this thread in order for me to track my activities soon if I have computer.
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/9yGDCS5
2. Choose your bounty for tracking. In example its XYO bounty.
Find own row in XYO spreadsheet.
https://imgur.com/aM1qhBi
Tab 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/T4sSU2D
This 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/2wZaqCP
5. 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/9yGDCS5
Check table here:
https://docs.google.com/spreadsheets/d/1DjlrBqKZPtGIh_pWZA4w_yKMLgRkdd67OVZJpPhm_sQ/edit#gid=0
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/9yGDCS5
2. Choose your bounty for tracking. In example its XYO bounty.
Find own row in XYO spreadsheet.
https://imgur.com/aM1qhBi
Tab 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/T4sSU2D
This 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/2wZaqCP
5. 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/9yGDCS5
Check table here:
https://docs.google.com/spreadsheets/d/1DjlrBqKZPtGIh_pWZA4w_yKMLgRkdd67OVZJpPhm_sQ/edit#gid=0
Jump to: