Quests & Challenges

Thanks!

@mysteriously @Galactina @dark78660 - Event Question

To claim the trophy badge, do we have to make it on either leaderboard at some point during the event, or only at the end with final counts?

Also can it only be claimed if we leaderboard for the total event? Or does making it on at the end of either week count?

I'm new to the PSH and having a great time. Preemptive thank you for answering!

Aye Aye Captain! That week went fast!

I am not much of a badge collector but I saw these books and I need them! Hope I entered correctly, first time doing this ~ This is my badge collection currently, for personal reference and to show off? If I'm to use them in my dragons bios, I need to know which ones I own ^^ [center][img]https://i.imgur.com/1RuFjQ2.png[/img][img]https://i.imgur.com/96LXII9.png[/img][img]https://i.imgur.com/zPDWw6f.png[/img][img]https://i.imgur.com/No6qloB.png[/img][img]https://i.imgur.com/QwbXNrc.png[/img][img]https://i.imgur.com/1Ms2eVu.png[/img][img]https://i.imgur.com/N2TUXaK.png[/img][img]https://i.imgur.com/XJ0qjx0.png[/img][img]https://i.imgur.com/GTrn4Pz.png[/img][img]https://i.imgur.com/quMt2hY.png[/img][img]https://i.imgur.com/kp7ZjoB.png[/img][img]https://i.imgur.com/OoefzOO.png[/img][img]https://i.imgur.com/x5I2E6c.png[/img][img]https://i.imgur.com/sMlhLyM.png[/img][br][img]https://i.imgur.com/hBNV8KM.gif[/img][/center] [center][img]https://i.imgur.com/DJUfxVn.gif[/img][img]https://i.imgur.com/p71lwkx.gif[/img][img]https://i.imgur.com/1qseNkq.gif[/img][img]https://i.imgur.com/h8fD4C0.gif[/img][img]https://i.imgur.com/ufbbuLF.gif[/img][img]https://i.imgur.com/GIS6wtC.gif[/img][img]https://i.imgur.com/zqPH8XJ.gif[/img][img]https://i.imgur.com/Hv3CrVI.gif[/img][img]https://i.imgur.com/KnM3AD4.gif[/img][img]https://i.imgur.com/3B2HNK1.gif[/img][br][img]https://i.imgur.com/hBNV8KM.gif[/img][br][br][br][img]https://i.imgur.com/hBNV8KM.gif[/img][br][br][img]https://i.imgur.com/Pjlha5I.gif[/img][br][img]https://i.imgur.com/hBNV8KM.gif[/img][br][br][br][img]https://i.imgur.com/hBNV8KM.gif[/img][/center]

I am very late to start this but it'll be interesting to see how much I can get done before the end.

[center]@pinglist-3873 [b]Bug Fix Post![/b] Hello hunters! It was pointed out to us that our code for unique items was a bit outdated and prone to breaking under the right conditions causing it to not give a correct count. On your [b]Summary Tab[/b] you will replace the following cells with the new codes. Just copy the contents of each code box, highlight the listed cell, paste the code, then press enter. You should get a pop up warning, press okay to confirm the change. Summary Tab, Cell S3 [code]=sum(countif(LootW1!G18:G20, ">0"), countif(LootW1!J7:Q17, ">0"), countif(LootW1!M18:N18, ">0"), countuniqueifs(LootW1!B23:B94, LootW1!F23:F94, ">0"), countuniqueifs(LootW1!I21:I94, LootW1!O21:O94, ">0"), countuniqueifs(LootW1!S3:S30, LootW1!T3:T30, ">0"), countuniqueifs(LootW1!S33:S94, LootW1!T33:T94, ">0"), countuniqueifs(LootW1!V3:V94, LootW1!W3:W94, ">0"), countuniqueifs(LootW1!Y3:Y94, LootW1!Z3:Z94, ">0"))+if(C7=0, 0, 1)[/code] [rule] Summary Tab, Cell U3 [code]=sum(countif(LootW2!G18:G20, ">0"), countif(LootW2!J7:Q17, ">0"), countif(LootW2!M18:N18, ">0"), countuniqueifs(LootW2!B23:B94, LootW2!F23:F94, ">0"), countuniqueifs(LootW2!I21:I94, LootW2!O21:O94, ">0"), countuniqueifs(LootW2!S3:S30, LootW2!T3:T30, ">0"), countuniqueifs(LootW2!S33:S94, LootW2!T33:T94, ">0"), countuniqueifs(LootW2!V3:V94, LootW2!W3:W94, ">0"), countuniqueifs(LootW2!Y3:Y94, LootW2!Z3:Z94, ">0"))+if(E7=0, 0, 1)[/code] [rule] Summary Tab, Cell W3 [code]=SUM(ARRAYFORMULA(SUM(IF(LootW1!J7:Q17>0,1,IF(LootW2!J7:Q17>0,1)))), ARRAYFORMULA(SUM(IF(LootW1!M18:N18>0,1,IF(LootW2!M18:N18>0,1)))), ARRAYFORMULA(SUM(IF(LootW1!G18:G20>0,1,IF(LootW2!G18:G20>0,1)))), Countunique(Iferror(FILTER(LootW1!B23:B94, LootW1!F23:F94>0),""), Iferror(FILTER(LootW2!B23:B94, LootW2!F23:F94>0),"")), Countunique(Iferror(FILTER(LootW1!I21:I94, LootW1!O21:O94>0),""), Iferror(FILTER(LootW2!I21:I94, LootW2!O21:O94>0),"")), Countunique(Iferror(FILTER(LootW1!S3:S30, LootW1!T3:T30>0),""), Iferror(FILTER(LootW2!S3:S30, LootW2!T3:T30>0),"")), Countunique(Iferror(FILTER(LootW1!S33:S94, LootW1!T33:T94>0),""), Iferror(FILTER(LootW2!S33:S94, LootW2!T33:T94>0),"")), Countunique(Iferror(FILTER(LootW1!V3:V94,LootW1!W3:W94>0),""), Iferror(FILTER(LootW2!V3:V94, LootW2!W3:W94>0),"")), Countunique(Iferror(Filter(LootW1!Y3:Y94, LootW1!Z3:Z94>0),""), Iferror(Filter(LootW2!Y3:Y94, LootW2!Z3:Z94>0),"")), if(G7=0, 0, 1))[/code] [rule] The personal sheet template has been updated to reflect these changes, so any new sheets made after this post will not need to make any changes. This issue doesn't effect the Raffle so we will be pulling winners for that later today! [emoji=d20 size=1]

@dark78660 should I be getting a "1" (one) listed in my uniques for week two after applying the fix above? I haven't added anything to my week two sheet yet.