<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 table below shows a list of shore leave requests from a pirate crew. The captain will only approve a request if both are true:

• The request doesn’t fall on one of that crew member’s watch duty days
• The crew member has less than $10,000 in gambling debt

The Approved? formula uses the and operator to ensure that both of these conditions are true. If so, it’ll output true and the request will be approved. If not, it’ll output false and the request will be denied.

• Full Reference

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

</aside>

Shore Leave Requests

Approved

if(
	prop("Gambling Debt") < 10000
	and !contains(
		join(
			prop("Watch Duty Days"), ", "
		), 
		formatDate(
			prop("Request Date"), "dddd"
		)
	), 
	true, 
	false
)

• More Formula Examples

© Thomas Frank