Thanks for the help! I copy/pasted into the new sheet, got everything organized and in their correct columns, tried pasting that text into the cell and now it's giving me this

@panther

No problem! For this error just make sure everything is deleted from Column L besides the formula in the first cell. (So in this case clear everything out of L14) is the error continues, clear out any other cell that it references.

The Array formula functions as if you're putting a formula into every cell in that column, but you only have to put it in the first cell. But since the array is technically overwriting everything in the column if you manually type anything into that column, you'll get an error like that.

If you need more help, feel free to ask!

Thank you!

@VariantLoki

Thanks for making this! I don't use census sheets on FR because inputting the data would take so long with so many dragons, but I figure right at the start is a good time to start maintaining one on LW and I'm enjoying the stats it gives me so far. Do you have an update pinglist I could be added to?

@TSerin

Thanks!

I know excalty how you feel. When I found the FR version of the sheet I had about 100 dragons at a time and it seemed like such a daunting task to add them all. I did it over the course if a few days in the end.

I can add you to an update pinglist for sure!

╰┈➤ ❝ Update! ❞

Pinglist: @Tserin

Good news! I've made another update to the sheet with new added functionality!

May 22nd, 2023

• Added a new, seperate sheet to track which companion is cucrently with each wolf
  • This sheet automatically imports your wolves names from the data input sheet and has a drop down system to select from all current companions
  • Once you select a companion, it's Item image will appear in the following cell!
  • You can also keep track of companion level, but this is manual entry.
• Add some some fun new stats to the Table Data sheet.
  • Sheet now keeps track of your heaviest and lightest wolves, tallest and shortest wolves, and Lowest and Highest ID wolves!

╰┈➤ ❝ Update! ❞

Update Pinglist: @TSerin

May 24th, 2023

• Added synergies for companions and added a 'Combined Synergies" column in the companion tracker sheet
  • This sheets should automatically update your wolves order/synergies when you add new wolves or move them around in the data input sheet.
  • Companion selection and level data are still manually selected, but the synergies will automatically update when changing companions.

Hiya! The ID Digits chart has the level 5 thing lumped in with it, for some reason- I'm not sure if this is a bug bit it sure looks like one /lh @VariantLoki

@VariantLoki Hey! I noticed that two of the colors are misspelled. Lolite should be Iolite (iolite) and Pthalo should be Phthalo :)

@Panther Thanks for pointing those out! These have both been fixed. I actually didn't even know it was Iolite (With an I), I just assumed it was a a typo and it was a Lowecase L. Woops!

You can either fix the spelling error on your sheet yourself by clicking on any column that has the colors (eyes/accent/top/etc) and going to Format > Conditional formatting. From there, scroll down until you find the misspelled colors in the list, and double click to enter edit mode. You can the fix the spelling by changing the color name in the text box.

@HellHarpi

Woops, that looks like a remnant from my copy/pasting the levels chart to make the ID's chart.

You can fix this by clicking on the ID chart, then double clicking on that label specificlly. This will pull up a menu on the right side. In the text formatting box, simply erase whatever is in there. This will change the table to be the default number of digits (4, 5, 6 etc)

if you want it to say 5 Digit/4 digit/ 3digit you can do the same thing. Double click the label and you can customize how it appears.