Guides

@ChibiFluffy So this is a weird little glitch. I wound up getting a new sheet and just copying all my data over, adding my new Undertides as I went through the process. For some reason, Undertides error out in the data tab, but appear just fine in the Census and Projects tabs? ::confusion:: Like, nothing really is broken aside from a little red mark yelling at me in the data tab and Undertides not having a colour on the Dragons tab. Every other tab populates just fine. Also, all the genes are fine. It's just the breed itself. lol

@KittyAoba

aaaa figured it out, I'm a dumdum and forgot there's some data validation on the data tab too D:

Gotta change the data validation for the breed column in Data Tab for "=ref_info!$M$2:$M"

Added a color for Undertide in dragon/selling tabs

Should be good now

Hey there! I've been putting my dragons n such into this sheet but I've come across an issue. My first couple project dragons work flawlessly. But as I've added more dragons and then another project dragon the formulas error out (I have done no editing other than remove the "iferror" to see what the error is). It says "did not find value (dragon id) in VLOOKUP evaluation" for the current breed function (that' the one I chose to investigate). I have confirmed the dragon is set up in the Data sheet and it shows up in the list to pick from, but it does not fill in the current genes etc. I'm rather experienced with spreadsheets (albeit in excel not google sheets) and am not seeing an obvious fix here. Any help would be appreciated.

For reference this is the dragon that is not working (though it isn't working with another one either): https://www1.flightrising.com/dragon/82117261

@CorgiBlu hey ! When this happens I've found it is because the ID is not formatted as text!
It's the only thing I can find that would make it not find the id ...

[quote name="ChibiFluffy" date="2022-11-25 14:02:29" ] @CorgiBlu hey ! When this happens I've found it is because the ID is not formatted as text! It's the only thing I can find that would make it not find the id ... [/quote] Hey that fixed it! Thanks for the reply!

@ChibiFluffy Awesome! Fixed, thank you. :)

Edit: Is it possible to edit out the sales stuff on the sheet without breaking everything? It's stuff I don't really need for tracking my lair. lol

@KittyAoba you should be able to take it out, I think the obly thing that would not work would be the selling tab and the "note" column in the dragon tab. I have not tested it

@ChibiFluffy Hi, I can't get the projects tab to work on the latest version. It doesn't work like the test sheet and I've even tried it on a brand new copy just to be sure.
Here's the sheet I'm using: https://docs.google.com/spreadsheets/d/1fnoIjmK3GnJvEG5Au6E4qrM-9FpyOeKgK7AxNwSvPpE/edit?usp=sharing

@ComicalDream01 Hey! It's the format of the ID on the Data Tab that has to be "Text" to work :D

Select the ID column and change the format to text, it will get that problem fixed :)

@ChibiFluffy Thank you!