@HellHarpi

No worries! I'm here to help and answer questions!

You actually don't have to do anything with the digits column. There is a formula in cell D3 that calculates it for you once you put your Wolfs ID into column C.

So for example: if your Wolfs ID is 1234, once you enter that, it will automatically put a 4 in column D.

As a fix check to see if cell D3 contains this formula:

=ARRAYFORMULA(IF(C3:C1001="", "", LEN(C3:C1001)))

If it doesn't, copy/paste the formula back into the cell and it should fix itself.

If that doesn't work, let me know if there any error code or #REF that shows up in the column.

@VariantLoki GOSH Thank you so much! I got the sheet working now, thank you for the clarification!

@HellHarpi

No problem! I'm glad the fix worked for you. If you have other issues or questions feel free to let me know :)

You said that there was coding in the age column, does it auto populate with the age when you put in their birthday? Mine isn't right now and I don't want to put something in and break the formulas if it's supposed to auto populate.

@Panther

Yes! The age column should auto populate when you put your wolfs birth year, month, and day into the correct columns.

If yours isn't working, follow these few steps to fix it

1. Erase anything that is currently in the age column
2. Click on the first cell under Age and paste this formula
   • =ArrayFormula(IF(I3:I1001<>"", TEXT(DATEDIF(DATE(I3:I1001, J3:J1001, K3:K1001), TODAY(), "Y") & " years, " & DATEDIF(DATE(I3:I1001, J3:J1001, K3:K1001), TODAY(), "YM") & " months, " & DATEDIF(DATE(I3:I1001, J3:J1001, K3:K1001), TODAY(), "MD") & " days", ""), ""))
     • Note that this formula assume that your birth year column is column I, birth month is column J, and birthday column is Column K. If you've added/removed any columns you made need to adjust the references. If you need help adjusting the formula let me know!
3. Press enter and your age column should auto populate for all your wolves!
   

New Update!

May 18th, 2023

• Added Functionality for displaying synergies depending on your wolfs breed.
  • New columns I - K will fill in Automatically once you enter your wolf breed!
  • This data references a hidden sheet, but you don't have to do anything with it to make it work.
  • Changed the “Age” column to use an Arrayformula, so that each cell doesn't have to have a formula individually.
    • If you want to update your age column from a previous version of the sheet, use this formula in the first cell below "Age::
      
      =ArrayFormula(IF(L3:L1001<>"", TEXT(DATEDIF(DATE(L3:L1001, M3:M1001, N3:N1001), TODAY(), "Y") & " years, " & DATEDIF(DATE(L3:L1001, M3:M1001, N3:N1001), TODAY(), "YM") & " months, " & DATEDIF(DATE(L3:L1001, M3:M1001, N3:N1001), TODAY(), "MD") & " days", ""), ""))
  • Froze Column B so that the wolf's name will stay static when your scroll left/right. This should make the sheet a bit easier to read.

Thank you so much for this. I'm excited at the idea of possibly, maybe being organised this game ‘round. It’s really cool! :D

Oh! I wanted to ask - When I type in “Pearl' and ”Watermelon", I think it's reading Pear and Water - I tried putting in the hex code, but I was wondering if I'm doing something wrong? I'm sorry about your hands, putting in all this code ;o;

@Drone

Glad you like the sheet!

Thanks for pointing out the error with those colors!

This is happening because I have all the conditional formatting set to “Contains: (Color name)” so for colors that contain other colors (in your case water/watermelon and pearl/pear) it's only taking the into account the first color in the list. I'm going to see if I can fix this and I'll update the post when I do!

@Drone

Sorry for the double ping, but I just wanted to let you know that I was able to fix the formatting error with these colors!

I went ahead and changed the formatting for a number of colors to “text is exactly” so it will only apply the formating for that specific color. I did this for all the colors you mentioned along with a few others.

If you want to fix the error on your copy of the sheet, you can follow these steps

1. Open the sheet and click on any of the rows where the colors appear
2. In the top bar click on “Format” and then “Conditional Formatting”
3. In the side bar that pops up on the right, scroll all the way dow until you find the colors that are displaying wrong (Water/watermelon, rose/rosemary/rosewood, etc) and click the color to edit it.
4. Under “format rules” change the dropdown box from “Text Contains” to “Text is Exactly". Do this for affected colors.

Of course, if you need help let me know!

Any pings are good, no worries! I will give it a go, and let you know if I need a hand. Thank you! ❤️