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 to do a lookup on two tables?

I have two tables (on different pages)
The first auto-creates a row each day, and looks like:

Table_1 

| Name | Created date | integer A |
---------------------------------------
| 1/1/2001| 1/1/2001  |    5      | 

The second table is also autogenerated, and looks similar to the following (although with two autogenerated rows per day

Table_2

| Name | Created date | integer B |
---------------------------------------
| type_1 | 1/1/2001  |    7      | 
-------------------------------------
| type_2 | 1/1/2001 | 8          |

I want the a way to get the following result

Table_1

| Name | Created date | integer A | value C |
-----------------------------------------------
| 1/1/2001| 1/1/2001  |    5      | (7+8)/2 |

A new row on Table_1 with the average of the values of B with the same creation time as the row on Table_2

Any ideas how to do so? I didn't manage using rollups and etc (and tried bing chat as well, just to make sure)

(In reality the first table is a habit tracker, and the second table is exercise with weights, reps and completion rate for each)

1 Answer

0vote

polle Points79930

Notion can't generate information like that. You will need an external tool like Make or Zapier to create an automation based on you needs.

1vote

ztomer commented

Thanks, I reached out for their support and asked whether queries are planned

0vote

polle commented

Support will not know that information and there is no public roadmap. No one knows what features will be available and when, so the right answer for now is that it is not possible unless you create the environment using external tools.

If you consider this as the solution, please select the answer to mark the question as solved.

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