Notion Formulas 2.0: Adding Up Sub-Items with Actual & Forecasted Minutes [1 layer]

[@Action2me]

I really wish Notion would just provide a calculated property that combines anything in the subtask the same way Clickup does. In Clickup, some fields like Hours and Sprint Points get automatically aggregated to the parent task. Having this in Notion would be a lot cleaner than having to create a totally separate field for subtask time tracking.

[@NotionWorkflow]

Agreed, wish they had something comparable to that. I haven't used Clickup before but that sounds like a great feature.

[@latand]

Thank you!

[@LootsIsLearning]

When writing the sum formulas, what would you add to the formula to show that if the Actual minutes were greater than the estimated minutes display the output in red and if the Actual minutes were less than the estimated minutes display in green?

[@NotionWorkflow]

I'd use a lets, ifs, and style formula functions. These two videos should help. kzbin.info/www/bejne/d3axfGOpqr6oh8k kzbin.info/www/bejne/pHfPhHyLYq-gkNE

[@foteinimantzali8691]

The whole purpose and great value of the Formulas v2.0 update is to keep our databases as clean as possible, and instead of polluting them with numerous, intermediate formula properties in order to calculate something complex, incorporate all the logic/processing inside a single formula property. That’s why they provided us with countless functions to traverse the data in any way we want. Your method works fine. But your solution in 90% based on the old way of thinking, and just 10% taking advantage of the new 2.0 features. Essentially you are using just the map() & lets() functions in a very minimalistic way. You could achieve the same results (and much more) using just a single formula property in the Projects db. Through the already established relationship to the Tasks db, formulas 2.0 give you all the tools (functions) you need to traverse the data up & down, perform calculations on them, and present them in any way you see fit (for example converting minutes to hours/minutes, etc). Nice tutorial (it gets the job done) but a little bit misleading for someone who wants to actually learn the true power of formulas 2.0.

[@NotionWorkflow]

Thanks for sharing your opinion! If you watch my other videos I demonstrate a variety of ways to use a singular formula property to manipulate many properties at once. "Misleading" is a strong word, and if you knew why I started this channel, which is to accessibly learn Notion Formulas, you'd understand what and why I'm sharing it the way that I am.

[@foteinimantzali8691]

@@NotionWorkflow I’m sorry if I offended you in any way. English is not my primary language and thus I may use words with greater impact than I intended to. You are absolutely right that I rushed to get to conclusions before watching more videos on your channel. I didn’t know the “build-up” process of your learning material. I just stumbled upon this single video while studying formulas 2.0 and immediately noticed the “old patterns” with a “2.0” title. I should have watched more of your content before expressing publicly my opinion and rush to judging. So, please accept my apologies. Despite that, congratulations on the way you responded to a somewhat negative comment. Learning material is plenty and all over, but actually intelligent people worth to intellect with are a dying breed. You have my respect and sub! Keep it up 👍

[@NotionWorkflow]

Thanks for sharing your perspective and your self-awareness! All good. 📈