Hey @Marlon_Needelman,
if I get your need right, you might have to add another column with “base candies”. That way, you can fill in the the candies of the base pokemon and with a lookup, you can print out this number in the “# of candies” for all releated evolution states.
Also you might need to add a “base pokemon” column. That way your formula can reference to it.
With these to extra columns, you don’t need a formula for every single cell. One formula fits for the whole column.
You can hide the extra columns, if they annoy you.
Here is an example:
Formula:
=Pokemon.lookup(Name,thisRow.[Base Name]).[Base Candies]
Does that fit your need?