Using relations, rollups, and formulas to organize content

(Scaling your team 5 of 9) Advanced database properties can help managers and admins alike make sense of large databases - learn how to use them in your org.
Get the templates, and more → notion.so/help/notion-academy

[@AntonioCostaAmaral]

The greatest shortcoming of these advanced properties is that you cannot do rollups of rollups. The explanation is that circular references might appear. Which is silly. Just have the system check if that creates some circular reference. If any database exists more than once on the chain of rollups, don't allow it. It this feature existed, you could be looking at (eg) a task, and see information of it's project, and of the project's people, and of their departments. Not existing, you have to go back and forth through databases, or include some information in the name, a big mess. Just do it please.

[@Doctor_CoRo]

I think you can do a formula property that shows your rollup and relate another rollup to that

[@toddlichtenwalter2041]

I am a school teacher wanting to convert my worksheets into Notion. Can I make a formula refer to a specific answer in another cell coming from a related table's data? In other words, I want to convert a simple fill in the blank worksheet into a table (questions) with relation column (answers in a separate answers table) and have a 3rd column (formula column) determine if the answer is correct and award points if correct as one might do in Excel e.g. IF(B2 = "photosynthesis", 5, 0)-- In this example
B2 is the answers selected from the choices in the answers column which happens to be a relations column to Answers table

[@akekalukardjnaphai464]

Can we calculate the number in roll up property? I can't do it. For example, I have separated table of clients as a profile database including ID, DOB, and etc. Then, I link the client's profile to another table, such as invoice tab which has date of purchasing. I try to create the new properties "Age (mean on that day)" on invoice table. But notion can't calculate the roll up parameter. It can only show the original value. Do you know how to fix this or please inform notion to fix this issue in the future.

[@jankaman4727]

this is all cute but how can I duplicate page / table without changing original page and vise versa ?

[@GregorSchafrothAI]

Please add table of contents :)

[@user-ff9jc3il6u]

For the database or for a page? I was able to make a table of contents for a page

[@GregorSchafroth]

@@user-ff9jc3il6u I'm talking about the RUclips Video haha

[@sanetersoy4512]

Notion needs a scripting language, formulas is not enough.

[@labulabuland]

0:49 🔖

[@ffsfagner]

What a useless video..