Polls

Yes/No Version

(prop("Yes") == "") ? 0 : (length(replaceAll(prop("Yes"), "[^,]", "")) + 1)

(prop("No") == "") ? 0 : (length(replaceAll(prop("No"), "[^,]", "")) + 1)

prop("Yes Count") / (prop("Yes Count") + prop("No Count"))

prop("No Count") / (prop("Yes Count") + prop("No Count"))

Result

(prop("Yes Count") == 0 and prop("No Count") == 0) ? "No Votes" : ((prop("Yes Count") > prop("No Count")) ? "Yes" : ((prop("Yes Count") == prop("No Count")) ? "Tied" : "No"))

Multiple Choice Version

Results (Comma)

replace(if(prop("Highest Vote") > 0, if(prop("Highest Vote") == prop("1 Count"), prop("Option 1") ? (prop("Option 1") + ", ") : "", "") + if(prop("Highest Vote") == prop("2 Count"), prop("Option 2") ? (prop("Option 2") + ", ") : "", "") + if(prop("Highest Vote") == prop("3 Count"), prop("Option 3") ? (prop("Option 3") + ", ") : "", "") + if(prop("Highest Vote") == prop("4 Count"), prop("Option 4") ? (prop("Option 4") + ", ") : "", "") + if(prop("Highest Vote") == prop("5 Count"), prop("Option 5") ? (prop("Option 5") + ", ") : "", ""), ""), ",(?=[^,]*$)", "")

Results (Boxed)

if(prop("Highest Vote") > 0, if(prop("Highest Vote") == prop("1 Count"), prop("Option 1") ? ("[ " + prop("Option 1") + " ]") : "", "") + if(prop("Highest Vote") == prop("2 Count"), prop("Option 2") ? ("[ " + prop("Option 2") + " ]") : "", "") + if(prop("Highest Vote") == prop("3 Count"), prop("Option 3") ? ("[ " + prop("Option 3") + " ]") : "", "") + if(prop("Highest Vote") == prop("4 Count"), prop("Option 4") ? ("[ " + prop("Option 4") + " ]") : "", "") + if(prop("Highest Vote") == prop("5 Count"), prop("Option 5") ? ("[ " + prop("Option 5") + " ]") : "", ""), "")

Results (New Line)

if(prop("Highest Vote") > 0, if(prop("Highest Vote") == prop("1 Count"), prop("Option 1") ? (prop("Option 1") + "\n") : "", "") + if(prop("Highest Vote") == prop("2 Count"), prop("Option 2") ? (prop("Option 2") + "\n") : "", "") + if(prop("Highest Vote") == prop("3 Count"), prop("Option 3") ? (prop("Option 3") + "\n") : "", "") + if(prop("Highest Vote") == prop("4 Count"), prop("Option 4") ? (prop("Option 4") + "\n") : "", "") + if(prop("Highest Vote") == prop("5 Count"), prop("Option 5") ? prop("Option 5") : "", ""), "")

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!