@ElvenArtist I'm very new to using this sheet, and not good at spreadsheets in general. Is there a way to add all the new sandswept delta fams at once and then still have it sort alphabetically? I can't figure out how to get them to sort alphabetically if I just add them all to the end. The last familiar spreadsheet I used, until it stopped updating, had you just add them in one by one, right where they should be in the order. I'm fine with doing that, but I was wondering if there's an easier way. Last time I tried adding them all to the end and then sorting alphabetically it royally screwed my sheet and I had to start from scratch.
TOPIC | [MistJam] Sheets Familiar Tracker
@ElvenArtist I'm very new to using this sheet, and not good at spreadsheets in general. Is there a way to add all the new sandswept delta fams at once and then still have it sort alphabetically? I can't figure out how to get them to sort alphabetically if I just add them all to the end. The last familiar spreadsheet I used, until it stopped updating, had you just add them in one by one, right where they should be in the order. I'm fine with doing that, but I was wondering if there's an easier way. Last time I tried adding them all to the end and then sorting alphabetically it royally screwed my sheet and I had to start from scratch.
@ShriektheMighty
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
[quote name="Gay4Space" date="2021-04-19 16:27:59" ]
Here are the steps I used to create my filter on my sheet so it doesn't disappear between uses and doesn't filter the first two rows. I use the dark sheet but it should work just fine on the regular one too.
Step 1: Select everything but Row 1. It should look something like this:
[img]https://i.ibb.co/6tfdKcR/example.png[/img]
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
[img]https://i.ibb.co/QCDsz4w/example2.png[/img]
To this:
[img]https://i.ibb.co/nzwjQHx/example3.png[/img]
Step 3: Done! You should be able to filter to your hearts content.
[/quote]
EDIT: You specifically want to select [i]to the end of the sheet[/i], and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
@ShriektheMighty
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
EDIT: You specifically want to select to the end of the sheet, and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
Gay4Space wrote on 2021-04-19 16:27:59:
Here are the steps I used to create my filter on my sheet so it doesn't disappear between uses and doesn't filter the first two rows. I use the dark sheet but it should work just fine on the regular one too.
Step 1: Select everything but Row 1. It should look something like this:
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
To this:
Step 3: Done! You should be able to filter to your hearts content.
Step 1: Select everything but Row 1. It should look something like this:
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
To this:
Step 3: Done! You should be able to filter to your hearts content.
EDIT: You specifically want to select to the end of the sheet, and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
[center][emoji=water rune size=1] [b]Wavecrest Saturnalia + Fiona Update[/b] [emoji=water rune size=1]
[/center]
[rule]
[center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center]
[rule]
Ahh I completely forgot I never posted this! My apologies everyone, I remember typing this out earlier this week but never ended up posting it [emoji=skydancer scared size=1]
I've added the [b]Flowing Taurus[/b], [b]Bluejay Gryphon[/b], and [b]Brilliant Gryphlet[/b] to the sheet. I've also added the corresponding Fiona entries for the latter two; check out [url=https://www1.flightrising.com/forums/link?url=https%3A%2F%2Fdocs.google.com%2Fdocument%2Fd%2F1cgbuRYnb4TBi8ZuVmZoGG1a4LSdqG2kdlw3TwSvLSgc%2Fedit%3Fusp%3Dsharing]this tutorial[/url] if you need help adding these!
The following corrections have also been added:
[LIST]
[*][u]Regular Familiars (both sheets):[/u] Charcoal Kitsune's item ID has had its spelling corrected from "Kistune"
[/LIST]
Happy Wavecrest! [emoji=skydancer happy size=1][emoji=blue star size=1]
[rule]
[center][size=1]
[emoji=scroll size=1]
[/size][/center]
Wavecrest Saturnalia + Fiona Update
Ahh I completely forgot I never posted this! My apologies everyone, I remember typing this out earlier this week but never ended up posting it
I've added the Flowing Taurus, Bluejay Gryphon, and Brilliant Gryphlet to the sheet. I've also added the corresponding Fiona entries for the latter two; check out this tutorial if you need help adding these!
The following corrections have also been added:
- Regular Familiars (both sheets): Charcoal Kitsune's item ID has had its spelling corrected from "Kistune"
Happy Wavecrest!
3 hours ahead of FR time
[quote name="Gryphonlady" date="2021-04-21 09:28:19" ]
@ShriektheMighty
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
[quote name="Gay4Space" date="2021-04-19 16:27:59" ]
Here are the steps I used to create my filter on my sheet so it doesn't disappear between uses and doesn't filter the first two rows. I use the dark sheet but it should work just fine on the regular one too.
Step 1: Select everything but Row 1. It should look something like this:
[img]https://i.ibb.co/6tfdKcR/example.png[/img]
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
[img]https://i.ibb.co/QCDsz4w/example2.png[/img]
To this:
[img]https://i.ibb.co/nzwjQHx/example3.png[/img]
Step 3: Done! You should be able to filter to your hearts content.
[/quote]
EDIT: You specifically want to select [i]to the end of the sheet[/i], and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
[/quote]
Maybe I'm just really messing this up but if I'm understanding it correctly, this should make it so you can sort by any category, right? I made a copy of my sheet to test it and sorting by ID then trying to sort alphabetically completely wrecked my sheet. Does it only work for a to z? I'm sorry I'm making this so difficult, I'm just very confused. I would have had to start my entire sheet over at least 5 times if I hadn't made a copy to test some of these fixes.
EDIT: I think I have figured out what I did wrong. It seems to be working now. Sorry for talking up space with my ineptitude!
Gryphonlady wrote on 2021-04-21 09:28:19:
@ShriektheMighty
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
EDIT: You specifically want to select to the end of the sheet, and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
@/Gay4Space described how to create a basic filter this on the prior page for another user. They did a lovely job capturing the steps, so I am just going to quote their work instead of recreating the instructions myself. :)
Once you create the filter as described below, you can sort the filtered range by any column - in this case, you would be interested in sorting the Name column using the 'Sort A - Z' option. Click on the arrow next to 'Name' and it will give you that option.
Gay4Space wrote on 2021-04-19 16:27:59:
Here are the steps I used to create my filter on my sheet so it doesn't disappear between uses and doesn't filter the first two rows. I use the dark sheet but it should work just fine on the regular one too.
Step 1: Select everything but Row 1. It should look something like this:
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
To this:
Step 3: Done! You should be able to filter to your hearts content.
Step 1: Select everything but Row 1. It should look something like this:
Step 2: Click the filter button on the toolbar at the top.
It should go from this:
To this:
Step 3: Done! You should be able to filter to your hearts content.
EDIT: You specifically want to select to the end of the sheet, and not to just the last familiar, so that when you add new familiars in the future they are automatically part of your filtered range and you don't have to go through these steps again.
Maybe I'm just really messing this up but if I'm understanding it correctly, this should make it so you can sort by any category, right? I made a copy of my sheet to test it and sorting by ID then trying to sort alphabetically completely wrecked my sheet. Does it only work for a to z? I'm sorry I'm making this so difficult, I'm just very confused. I would have had to start my entire sheet over at least 5 times if I hadn't made a copy to test some of these fixes.
EDIT: I think I have figured out what I did wrong. It seems to be working now. Sorry for talking up space with my ineptitude!
[center][emoji=nature rune size=1] [b]Greenskeeper Gathering[/b] [emoji=nature rune size=1]
[/center]
[rule]
[center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center]
[rule]
Hello everyone!
I've added the [b]Sprouting Gemini[/b] and [b]Curious Jeweler[/b] to the sheet. I've also made some corrections, listed below. Thanks to those who submitted these errors!
Happy Gathering! [emoji=skydancer laughing size=1][emoji=ivy leaf size=1]
[u][b]Regular Familiars (both sheets)[/b]:[/u]
[LIST]
[*]Furious Faun; spelling corrected (incorrect spelling is Furious Fawn)
[/LIST]
[u][b]Gathering Guide (both sheets)[/b] | The following familiars have had their level adjusted to 0+:[/u]
[LIST]
[*]Dappled Dunhoof
[*]Trick of the Light
[*]Hydra Scorpion
[*]Manticore
[*]Darktouched Chimera
[*]Hippojay
[/LIST]
[u][b]Gathering Guide (both sheets)[/b] | The following familiars have had their level adjusted to 1+ and locations corrected (if needed):[/u]
[LIST]
[*]River Muck
[*]Grey River Flight; locations corrected to Arcane, Shadow, Lightning, and Water.
[*]Ancient Fungus; Lightning removed from list of locations.
[*]Storm Seeker; Ice removed from list of locations.
[*]Death Seeker
[*]Longneck Skirmisher
[/LIST]
[u][b]Gathering Guide (both sheets)[/b] | The following familiars have had location corrections or other changes:[/u]
[LIST]
[*]Hippojay (DARK SHEET); Plague, Water, and Wind removed from location list.
[*]Glowing Pocket Mouse; locations corrected to Earth, Wind, Ice, and Plague
[*]Firebug; Lightning removed from list of locations
[*]Chimera; Arcane removed from list of locations
[*]Charoite Burrower; Ice removed from list of locations
[*]Enstatite Burrower; Earth removed from list of locations
[*]Corundum Chameleon; locations corrected to Arcane, Light, Lightning, Water, Wind, Nature
[*]Nephrite Chameleon; locations changed to Earth, Plague, Ice, Shadow, Fire
[/LIST]
[rule]
[center][size=1]
[emoji=scroll size=1]
[/size][/center]
Greenskeeper Gathering
Hello everyone!
I've added the Sprouting Gemini and Curious Jeweler to the sheet. I've also made some corrections, listed below. Thanks to those who submitted these errors!
Happy Gathering!
Regular Familiars (both sheets):
- Furious Faun; spelling corrected (incorrect spelling is Furious Fawn)
Gathering Guide (both sheets) | The following familiars have had their level adjusted to 0+:
- Dappled Dunhoof
- Trick of the Light
- Hydra Scorpion
- Manticore
- Darktouched Chimera
- Hippojay
Gathering Guide (both sheets) | The following familiars have had their level adjusted to 1+ and locations corrected (if needed):
- River Muck
- Grey River Flight; locations corrected to Arcane, Shadow, Lightning, and Water.
- Ancient Fungus; Lightning removed from list of locations.
- Storm Seeker; Ice removed from list of locations.
- Death Seeker
- Longneck Skirmisher
Gathering Guide (both sheets) | The following familiars have had location corrections or other changes:
- Hippojay (DARK SHEET); Plague, Water, and Wind removed from location list.
- Glowing Pocket Mouse; locations corrected to Earth, Wind, Ice, and Plague
- Firebug; Lightning removed from list of locations
- Chimera; Arcane removed from list of locations
- Charoite Burrower; Ice removed from list of locations
- Enstatite Burrower; Earth removed from list of locations
- Corundum Chameleon; locations corrected to Arcane, Light, Lightning, Water, Wind, Nature
- Nephrite Chameleon; locations changed to Earth, Plague, Ice, Shadow, Fire
3 hours ahead of FR time
[center][emoji=light rune size=1] [b]Brightshine Jubilee + Capricorn[/b] [emoji=light rune size=1]
[/center]
[rule]
[center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center]
[rule]
Hello everyone!
I've added the [b]Marble Lightweaver[/b] and [b]Sparkling Capricorn[/b] to the sheet. If you missed my last update, see [url=https://www1.flightrising.com/forums/gde/2876351/9#post_47674385]here[/url] for some corrections!
Have a great festival! [emoji=skydancer star size=1][emoji=gold star size=1]
[rule]
[center][size=1]
[emoji=scroll size=1]
[/size][/center]
Brightshine Jubilee + Capricorn
Hello everyone!
I've added the Marble Lightweaver and Sparkling Capricorn to the sheet. If you missed my last update, see here for some corrections!
Have a great festival!
3 hours ahead of FR time
[center][emoji=lightning rune size=1] [b]Thundercrack Carnivale[/b] [emoji=lightning rune size=1]
[/center]
[rule]
[center][url=https://docs.google.com/spreadsheets/d/1_1-9XnlJzDZy4vzt3dz2fKX6Mo8UOwYHVDBrzDOcSpc/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1Kk5VFmMcGamiV5uLbM8P1_9fPLb8BXnc83SSXuQmpec/edit?usp=sharing]Blank Sheet[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLScXoXk0HygLtGACZe9R1dv_lZ4BDOnURpr3eOR5mCs7uwInSg/viewform?usp=sf_link]Join Pinglist[/url] | [url=https://docs.google.com/forms/d/e/1FAIpQLSedO2ro15SmxgIbNcypv4qCIgSGWAecfuiLSC3veM-bRC-WlQ/viewform?usp=sf_link]Pinglist Removal[/url][/center]
[rule]
Hello everyone! Just a tiny routine festival update [emoji=skydancer winking size=1]
I've added the [b]Sandstone Stormcatcher[/b] to the sheet. You'll find it under its usual section, "Holiday and Retired Familiars".
Have a great festival! [emoji=skydancer tongue size=1][emoji=gear size=1]
[rule]
[center][size=1]
[emoji=scroll size=1]
[/size][/center]
Thundercrack Carnivale
Hello everyone! Just a tiny routine festival update
I've added the Sandstone Stormcatcher to the sheet. You'll find it under its usual section, "Holiday and Retired Familiars".
Have a great festival!
3 hours ahead of FR time