Missions → Total People

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

Pods → Total People

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

Pods → Total Eng

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

Pods → Total Product

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

Pods → Total Design

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

People → 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"))

People → Eng

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

People → Product

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

People → Design

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