Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

How can I make a formula across two databases?

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 :')enter image description hereenter image description here

1 Answer

0vote

polle Points40070

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".

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect