@Strade THANK YOU!!!!
TOPIC | [Spreadsheet] Fancy Familiar Tracker
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream
Spreadsheets have been updated with the new familiars. ^^ And I kept the "New to sheet?" column labelled for the two recent Kitsune familiars just 'cause these updates were so close together.
@Charoula @YouThereYeaYou @Nixifer @Kattata
I believe you guys were the pinglist for the self-updating spreadsheet? If I'm wrong, or you don't wanna be pinged again, just let me know.
The self-updating sheet it only went up to number 629. New rows were automatically added, they just didn't keep the formatting. So if you don't mind, then you don't have to do anything. If you want to keep the original formatting, just highlight some of the rows above the last one (Don't highlight the last one. Do any row before 628 and you're good), right click, and select "Insert # below" or above and just keep doing that until you have as many rows as you want. And then you can just highlight, right click, and delete all the unformatted rows if you'd like.
You're also gonna have to drag down the formula for the Linky Link column. Just highlight one, click and drag down the formula and you're set.
For those of you who use the filter views, I think a lot of them will only go up to 629. So where it says "Range: A1:S629" just change the 629 to some other number.
For people who're interested, the self-updating sheets are linked HERE (or the text version HERE), and is pretty much the exact same as the usual one, except the familiars are not in alphabetical order and you won't have to bother updating the sheet. Unless if there's a new coliseum venue or new year of festival familiars.
Spreadsheets have been updated with the new familiars. ^^ And I kept the "New to sheet?" column labelled for the two recent Kitsune familiars just 'cause these updates were so close together.
@Charoula @YouThereYeaYou @Nixifer @Kattata
I believe you guys were the pinglist for the self-updating spreadsheet? If I'm wrong, or you don't wanna be pinged again, just let me know.
The self-updating sheet it only went up to number 629. New rows were automatically added, they just didn't keep the formatting. So if you don't mind, then you don't have to do anything. If you want to keep the original formatting, just highlight some of the rows above the last one (Don't highlight the last one. Do any row before 628 and you're good), right click, and select "Insert # below" or above and just keep doing that until you have as many rows as you want. And then you can just highlight, right click, and delete all the unformatted rows if you'd like.
You're also gonna have to drag down the formula for the Linky Link column. Just highlight one, click and drag down the formula and you're set.
For those of you who use the filter views, I think a lot of them will only go up to 629. So where it says "Range: A1:S629" just change the 629 to some other number.
For people who're interested, the self-updating sheets are linked HERE (or the text version HERE), and is pretty much the exact same as the usual one, except the familiars are not in alphabetical order and you won't have to bother updating the sheet. Unless if there's a new coliseum venue or new year of festival familiars.
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream
Spreadsheets have been updated with the new familiars. ^^ And I kept the "New to sheet?" column labelled for the two recent Kitsune familiars just 'cause these updates were so close together.
@Charoula @YouThereYeaYou @Nixifer @Kattata
I believe you guys were the pinglist for the self-updating spreadsheet? If I'm wrong, or you don't wanna be pinged again, just let me know.
The self-updating sheet it only went up to number 629. New rows were automatically added, they just didn't keep the formatting. So if you don't mind, then you don't have to do anything. If you want to keep the original formatting, just highlight some of the rows above the last one (Don't highlight the last one. Do any row before 628 and you're good), right click, and select "Insert # below" or above and just keep doing that until you have as many rows as you want. And then you can just highlight, right click, and delete all the unformatted rows if you'd like.
You're also gonna have to drag down the formula for the Linky Link column. Just highlight one, click and drag down the formula and you're set.
For those of you who use the filter views, I think a lot of them will only go up to 629. So where it says "Range: A1:S629" just change the 629 to some other number.
For people who're interested, the self-updating sheets are linked HERE (or the text version HERE), and is pretty much the exact same as the usual one, except the familiars are not in alphabetical order and you won't have to bother updating the sheet. Unless if there's a new coliseum venue or new year of festival familiars.
Spreadsheets have been updated with the new familiars. ^^ And I kept the "New to sheet?" column labelled for the two recent Kitsune familiars just 'cause these updates were so close together.
@Charoula @YouThereYeaYou @Nixifer @Kattata
I believe you guys were the pinglist for the self-updating spreadsheet? If I'm wrong, or you don't wanna be pinged again, just let me know.
The self-updating sheet it only went up to number 629. New rows were automatically added, they just didn't keep the formatting. So if you don't mind, then you don't have to do anything. If you want to keep the original formatting, just highlight some of the rows above the last one (Don't highlight the last one. Do any row before 628 and you're good), right click, and select "Insert # below" or above and just keep doing that until you have as many rows as you want. And then you can just highlight, right click, and delete all the unformatted rows if you'd like.
You're also gonna have to drag down the formula for the Linky Link column. Just highlight one, click and drag down the formula and you're set.
For those of you who use the filter views, I think a lot of them will only go up to 629. So where it says "Range: A1:S629" just change the 629 to some other number.
For people who're interested, the self-updating sheets are linked HERE (or the text version HERE), and is pretty much the exact same as the usual one, except the familiars are not in alphabetical order and you won't have to bother updating the sheet. Unless if there's a new coliseum venue or new year of festival familiars.
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream
Spreadsheets updated with Spirit of Ice familiar. :D
Spreadsheets updated with Spirit of Ice familiar. :D
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream
Spreadsheets updated with Spirit of Ice familiar. :D
Spreadsheets updated with Spirit of Ice familiar. :D
@Rosoidela
I'm loving the spreadsheet but I'm having problems with the filters. no matter what is on The Blooming Groves familiars are always showing. Any idea why?
I'm loving the spreadsheet but I'm having problems with the filters. no matter what is on The Blooming Groves familiars are always showing. Any idea why?
@Rosoidela
I'm loving the spreadsheet but I'm having problems with the filters. no matter what is on The Blooming Groves familiars are always showing. Any idea why?
I'm loving the spreadsheet but I'm having problems with the filters. no matter what is on The Blooming Groves familiars are always showing. Any idea why?
@Snowfarm Hi! When you click into a filter, you can click the little arrow next to Source. Is the Coliseum/Blooming Grove label checkmarked? If so, then uncheck it, click OK, and it'll fix it for that filter. Unfortunately, you'd then have to do it for every other filter, so it might take you a li'l bit of time to fix that.
If you still end up having problems, or have any other questions, feel free to let me know. ^-^
If you still end up having problems, or have any other questions, feel free to let me know. ^-^
@Snowfarm Hi! When you click into a filter, you can click the little arrow next to Source. Is the Coliseum/Blooming Grove label checkmarked? If so, then uncheck it, click OK, and it'll fix it for that filter. Unfortunately, you'd then have to do it for every other filter, so it might take you a li'l bit of time to fix that.
If you still end up having problems, or have any other questions, feel free to let me know. ^-^
If you still end up having problems, or have any other questions, feel free to let me know. ^-^
@Rosoidela
That seems to work...I was doing via data>filter views and it would only let me select 1 thing. Doing via the drop-down menu next to the source works! Thank you!
That seems to work...I was doing via data>filter views and it would only let me select 1 thing. Doing via the drop-down menu next to the source works! Thank you!
@Rosoidela
That seems to work...I was doing via data>filter views and it would only let me select 1 thing. Doing via the drop-down menu next to the source works! Thank you!
That seems to work...I was doing via data>filter views and it would only let me select 1 thing. Doing via the drop-down menu next to the source works! Thank you!
@Rosoidela
This is amazing work! I'm not really accustomed to google sheets but what a better way to start.
You may add me to the pinglist if you like :D
This is amazing work! I'm not really accustomed to google sheets but what a better way to start.
You may add me to the pinglist if you like :D
@Rosoidela
This is amazing work! I'm not really accustomed to google sheets but what a better way to start.
You may add me to the pinglist if you like :D
This is amazing work! I'm not really accustomed to google sheets but what a better way to start.
You may add me to the pinglist if you like :D
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream @LadySiren
Spreadsheets have been updated with the new Waterway familiars. ^^
Spreadsheets have been updated with the new Waterway familiars. ^^
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream @LadySiren
Spreadsheets have been updated with the new Waterway familiars. ^^
Spreadsheets have been updated with the new Waterway familiars. ^^
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream @LadySiren
Spreadsheets updated with Spirit of Shadow familiar. :D
Spreadsheets updated with Spirit of Shadow familiar. :D
@Xari @Charoula @ouranographer @StormEater @Roadkill @Twinkletoe @Xinda @Cluttermouse @MusMusculus @Nono @speedythedino @xxmusical @tawnyowl @Loulybob @Siscily @SimFeetUnder @dogking @SkyTiger @Erevenile @absolmon @Rosoidela @Kimdra @Hinumi @Shewolf13 @CdrPhoenix @starspun @Airys @xReddifx @CraftyBookwyrm @possumrot @YouThereYeaYou @Calidragon @FruityHoofbeast @Erzdrache @Harbinger @Kavryn @Cyranelle @Ravengyre @Lya @CinnaPhoenix @kariann02 @LaAstaria @GarnetRose @stealthclaw @Maebirb @WolfsbaneAvis @Kholin @Hyacindy @avianAnnihilator @loracarol @UnhappyJoker @Northernly @Starstream @LadySiren
Spreadsheets updated with Spirit of Shadow familiar. :D
Spreadsheets updated with Spirit of Shadow familiar. :D