<aside> 📖 Properties required

1. Formula property called “Generation” Generation Number
2. Select property called “Through” with the following options: What Is A Through Member?
   1. Through
   2. Non-Through
3. Select property called “Gender” with the following options:
   1. Male
   2. Female </aside>

Relation

if(prop("Generation") == 1, "Root", if(prop("Generation") < 3 and prop("Gender") == "Male" and prop("Through") == "Through", "Father", if(prop("Generation") < 3 and prop("Gender") == "Female" and prop("Through") == "Through", "Mother", if(prop("Generation") < 3 and prop("Gender") == "Male" and prop("Through") == "Non-Through", "Uncle", if(prop("Generation") < 3 and prop("Gender") == "Female" and prop("Through") == "Non-Through", "Aunt", if(prop("Generation") < 4 and prop("Gender") == "Male" and prop("Through") == "Through", "Grandfather", if(prop("Generation") < 4 and prop("Gender") == "Female" and prop("Through") == "Through", "Grandmother", if(prop("Generation") < 4 and prop("Gender") == "Male" and prop("Through") == "Non-Through", "Great Uncle", if(prop("Generation") < 4 and prop("Gender") == "Female" and prop("Through") == "Non-Through", "Great Aunt", if(prop("Generation") >= 4 and prop("Gender") == "Male" and prop("Through") == "Through", format(prop("Generation") - 3) + "x Grandfather", if(prop("Generation") >= 4 and prop("Gender") == "Female" and prop("Through") == "Through", format(prop("Generation") - 3) + "x Grandmother", if(prop("Generation") >= 4 and prop("Gender") == "Male" and prop("Through") == "Non-Through", format(prop("Generation") - 2) + "x Great Uncle", if(prop("Generation") >= 4 and prop("Gender") == "Female" and prop("Through") == "Non-Through", format(prop("Generation") - 2) + "x Great Aunt", "")))))))))))))

Breakdown

Generation 1 = Root

Generation 2 + Through Member + Male = Father

Generation 2 + Through Member + Female = Mother

Generation 2 + Non-Through Member + Male = Uncle

Generation 2 + Non-Through Member + Female = Aunt

Generation 3 + Through Member + Male = Grandfather

Generation 3 + Through Member + Female = Grandmother

Generation 3 + Non-Through Member + Male = 1x Uncle

Generation 3 + Non-Through Member + Female = 1x Aunt

Generation ≥ 4 + Through Member + Male/Female = #x Grandfather