I am trying to get a summary of a single select column from a referenced table. The idea is kind of referencing cakes that can be of different types. Using a formula like this:
This displays all the single select values. So if the referenced cakes are 10 cherry crumbles and 10 cheese cakes, the cell will display 20 tags. But I would just like to get the 2 unique values here. Is this possible with a formula?
is that what you want to achieve? You reference multiple values from the table “Cakes” to “Table1”.
Now you would like to remove duplicate values like I did manually in the column "Remove duplicates?
This will require an enterprise account, but then you could accomplish your requirement.
Thanks Christoph, yes the screenshot shows the result I’m looking for. So I’d need a script, which is not too bad.
I like how notion handles such “rollups”: depending on the type of referenced column, it offers some standard summarization options. You can for instance display lowest, highest, or average value, earliest date, latest date, time span, unique values, etc. It’s quite useful and reduces the instances you have to deal with formulas, maybe something that SeaTable could offer as well.
- use link formula
SeaTable also offers such rollup functions. It is called “Link formula”.
Right now these formulas are supported:
Still there is no possibility to remove duplicates right now.
- use a formula
also you could use any formula in SeaTable with a link column. But right now there is no formula for “remove duplicates.”
In summary: right now you have to go with a custom script in combination with an automation.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.