Viewing flexibility will be covered in a minute, but most of the time there are elements that I don’t need to see, I just want an output that can be calculated. When looking to display the information I am storing in a database, I want the ability to see all that I need at a glance. The numbers at the bottom of the table cannot be referenced by a formula, so if I am looking to do more with the number calculated, I would need to consider using a rollup or a formula. It is worth adding at this point, I also take into consideration what I am going to be doing with the numbers afterwards. If I can’t find a way to use a rollup or table function for calculations, then will I make a formula to do the calculation for me. Or I will see if I can use the table calculations to display the number I am looking for, manipulating the linked database feature to use filters to find the information I am looking for. If I am looking at calculating something, I will look to see if I can use a rollup to get the number. I will go into further detail about the types of formulas later on but, I will always look for a solution that doesn’t require a formula first. Then, depending on those answers I will then look into what type of formula I may need. Is this going to solve a friction point?.
Can I already filter for this information?.This output can be used for 3 main things:īut before using a formula I ask myself these questions:
A formula uses current information in a database, to form a dependant output. At some point, you will look into the advanced properties and see relation, rollup and formula.įormulas can do 1 thing, but it can lead to many other options. Notion opens up a world of possibilities especially when you start to include databases in your workspace. Or go through my examples database on my public Notion page. If you are looking for more examples of formulas in Notion you can check out the Notion Formula tutorial playlist. Or if you would prefer to have a look at a video example, you might enjoy this “Formula tutorial for beginners”. I don’t work for Notion, nor do they sponsor me for any of the work I do online, through my YouTube channel, consultations or digital products, however, like many people in the Notion community, I love to share what I have learnt. My Notion workspace is always changing but, having the knowledge with formulas gives me another level of flexibility I can play with. I was not completely lost having had experience with excel formulas, but with no knowledge of coding, it took a lot of time and effort to understand what I was doing in the formula property. It just so happened that I found myself wanting to see more condensed views of information, and to calculate certain things in my Notion space. This is now where I point people when starting in Notion, and to make things easier I made a starter workspace Template. Then I realised databases were a more efficient way to organize what I needed to do, with filter and sorting abilities. My first Notion workspace was a page with what seemed like an endless list of to-do blocks. I’ve been using Notion for almost 3 years at this point for my task, project, knowledge, and business management.
0 kommentar(er)
