<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" /> This example database records the powerlifting totals for a few lifters, and compares them against the USPA standards for different lifting levels. The Level formula outputs the lifter’s current level.

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

</aside>

Powerlifting Status

prop("Name") 
	+ "'s Level is " 
	+ ifs(
		prop("Total") >= 1642, "Elite", 
	  prop("Total") >= 1508, "Master", 
	  prop("Total") >= 1355, "Class I", 
	  prop("Total") >= 1191, "Class II", 
	  prop("Total") >= 1041, "Class III", 
	  prop("Total") >= 903, "Class IV",
		"Novice"
	)

© Thomas Frank