Formula
if beyond_tier_1 == "Yes" && direct == "Yes" "Both" else if beyond_tier_1 == "Yes" "Beyond Tier 1 Supply Chain" else if direct == "Yes" "Direct Supply Chain" else "Neither"
if beyond_tier_1 == "Yes" && direct == "Yes" "Both" else if beyond_tier_1 == "Yes" "Beyond Tier 1 Supply Chain" else if direct == "Yes" "Direct Supply Chain" else "Neither"