Question

Hello, I'm trying to figure out how to make this formula across two different databases but since this my first time trying to write a formula I'm having quite a hard time.

I want the checkbox for the "can make" column in the Meals database to be checked, if all the ingredients needed for that meal in the Pantry database have the checkbox for the "have" column checked.

Hope this makes sense please help :')

Answer 1

Here is an easy way to do it using your Notion setup as it is.

1- In the meals database create a Rollup property called "Have". In the Rollup options select ingredients for relation, have for property and percent checked for calculate.

2- In the meals database create a new formula property and use the following Notion formula.

if(prop("Have") == 100 / 100, "Ready to Do", "No")

With this Notion will know if the ingredients are 100% checked and if that is the case you will get a "Ready to Do", otherwise you will get a "No".