How to fix duplicate Google Sheets Achievements

To fix this problem, both leaderboards need to be running on different columns, even if the scores are the same. 

To avoiding entering scores twice, you can set the value of the new score column to equal the value of the original score column with a formula.

First, in your google sheet, add the header for the new score column:

image.png

Then, set a formula for the first cell in the new column (C2) by selecting the cell, and pressing '=':

image.png

Then click the first cell in the original column:

image.png

And press 'Enter' to finish setting the formula:

image.png

Next, click and drag the fill handle (blue square in bottom right of cell C2)  down the column to apply the formula to the rest of the cells:

image.png

Now whenever the scores are updated in the Score A column, the Score B column will also be automatically updated.

Once the sheet is set up, go into Spinify and edit the two leaderboards that previously used the same score column in your google sheet so that one leaderboard uses Score A and the other leaderboard uses Score B.

Now your google sheets achievements will only fire once.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.