Question

Hello all,

I have a table where I am calculating a value with a rollup.
I would like to write a text where I use this result. is it possible in Notion ?

Thanks

Comments

Please extend a bit the information to understand the complete setup and what are you trying to accomplish.

How are you calculating it? In another column with a formula? What formula? What text you want to add? Etc...

---

Hello,

I have a first table call CA with 4 properties. Name, Start Date, sum, relation
relation is the list of related items in a second table.
sum is a rollup based on the relation, with a number property and the formula sum.

in another page I have 3 blocks text.

in this text I would like to have the value of sum in CA where name="CA A1"

in this one the I would like to have the value of sum in CA where name="CA A2"

here the sum for the max start date (start date)

---

I was going to create a Notion page test to share and help you, but before that I will confirm to see if I am understanding correctly.

*If you can duplicate to share your page and just leave the example, that would help.

You have this:

| Name | Start Date | Sum | Relation |
|------|------------|-----|----------|
| A1   | April 4    | 15  | Rel 1    |
| A2   | April 5    | 18  | Rel 2    |
| A3   | April 6    | 22  | Rel 3    |

And you need another table to show this:

| Block 1   | Block 2   |
|---------  |---------  |
| CA A1     | 15        |
| CA A2     | 18        |
| CA A3     | 22        |

Is that correct?
The custom text you need is CA A1?
Also, table 1 already shows that sum you want in the sum column.

What am I missing?

---

I am not familiar with sharing so I hope this is ok

https://www.notion.so/essai-bbfb452ea7b54c05a5d3e6b2ded84863

---

Thanks, almost. Just go to that page top right corner, click share and activate it.

---

I thought it was ok :(
is it ok now ?

---

Yes! Leave it there please, I'll take a look at it and help you asap.

Answer 1

For CA A* Sums.

1- Create a Linked database (/linked) and select the CA Table.
2- + Add a view > List View
3- Filter: Where > Name > Contains > CA A1
4- ••• > Properties: Just Sum active

Repeat for CA A2 and just modify step 3 with the correct name.

What I don't understand is "the sum for the max start date (start date)".

Hope that helps.