<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> The example database below tracks votes amongst a pirate crew.

For each issue, a quorum must be reached; at least 3 members must vote. Once a quorum is reached, only proposals that receive more Yays than Nays will be passed and enacted.

The Result formula displays the status of each proposal.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Pirate Vote Tracker

lets(
	yay, 1,
	nay, -1,
	toNumber(!empty(prop("Luffy"))) 
	+ toNumber(!empty(prop("Nami"))) 
	+ toNumber(!empty(prop("Sanji"))) 
	+ toNumber(!empty(prop("Zoro"))) < 3
	? "✋ Quorum Not Reached!" 
	: (
			(
				(
					(
						(
							toNumber(
								replaceAll(
									replaceAll(
										prop("Luffy"), "Nay", "-1"
									), "Yay", "1"
								)
							) 
							+ toNumber(
								replaceAll(
									replaceAll(
										prop("Nami"), "Nay", "-1"
									), "Yay", "1"
								)
							)
						) 
						+ toNumber(
							replaceAll(
								replaceAll(
									prop("Sanji"), "Nay", "-1"
								), "Yay", "1"
							)
						)
					) 
					+ toNumber(
						replaceAll(
							replaceAll(
								prop("Zoro"), "Nay", "-1"
							), "Yay", "1"
						)
					)
				) < 1
			) 
			? "👎 Rejected" 
			: "👍 Passed"
	)
)

© Thomas Frank