→ Total People

(prop("Mission Leads") ? (length(replaceAll(prop("Mission Leads"), "[^,]", "")) + 1) : 0) + (prop("Members") ? (length(replaceAll(prop("Members"), "[^,]", "")) + 1) : 0)

→ Total People

(prop("Pod Leads") ? (length(replaceAll(prop("Pod Leads"), "[^,]", "")) + 1) : 0) + (prop("Members") ? (length(replaceAll(prop("Members"), "[^,]", "")) + 1) : 0)

→ Total Eng

prop("Lead Eng") + prop("Eng")

→ Total Product

prop("Lead Product") + prop("Product")

→ Total Design

prop("Lead Design") + prop("Design")

→ Allocation

if((prop("Projects") ? (length(replaceAll(prop("Projects"), "[^,]", "")) + 1) : 0) > 2, "🔴 Over-subscribed", if((prop("Projects") ? (length(replaceAll(prop("Projects"), "[^,]", "")) + 1) : 0) > prop("Maximum Projects per Person"), "🟠 Over-allocated", prop("Projects") ? "" : "🟡 Under-subscribed"))

→ Eng

(prop("Role") == "Eng") ? prop("Name") : format(toNumber(""))

→ Product

(prop("Role") == "Product") ? prop("Name") : format(toNumber(""))

→ Design

(prop("Role") == "Design") ? prop("Name") : format(toNumber(""))