Is there a way for a set of calculation fields to pull from another set of fields, but only in a kind of cascading way? In other words, Field 1 pulls from Field A, and Field 2 pulls from Field B. However, if there is nothing in Field A or if it has the wrong kind of parameters, Field 1 pulls from Field B and Field 2 pulls from Field C. Is this making any sense?
Actually, according to the "Tag This Question" section, I may be looking for a something called "conditional copy". Potentially, I could use a "number amount = number amount means the field was already copied and use the next field instead", but that only works if each field has a different number amount, and sometimes they don't.