![[Study Group Report] We held a Notion Formula Study Group!](http://kurashi-notion.com/cdn/shop/articles/2510_notionblog_formulaseminar_967275ed-a27f-4af8-ab02-34ca3ee3f96a.jpg?v=1762425140&width=1920)
💡The " Notion Community for Daily Life " is now open!
By subscribing, you can read all paid articles , and you also get benefits such as Notion support for questions and study sessions . Click here to join the community where you can connect with many Notion users!
We held a Notion formula study session in the Life and Notion community!
Many people have difficulty using Notion's formulas. The way they are written and the functions they use are unique, making them difficult to use.
At the study session, we explained the rules for writing formulas, the formulas you should learn first, and the newly introduced Notion AI function for writing formulas!
This time, we will introduce a little bit of what it is like.
📝 How to write math formulas in Notion
The first thing I explained was how to write mathematical formulas in Notion.
There are two ways to write functions in Notion.
① Using a dot ② Using parentheses
We recommend the dot notation (1). By typing the dot, you can narrow down the options, making it easy to use even if you don't remember the formula.
💡Functions to learn first
Next, we will introduce some commonly used functions.
Each participant introduced use cases they had used and explained them while actually writing functions on the spot.
dateBetween | Calculate the period between dates
The first function is dateBetween, which calculates the number of days or hours in a period.
The period from start to finish can be expressed in various units such as days, hours, and minutes.
At the study session, we demonstrated how to calculate the number of days and hours taken based on the task's end date and start date.
now/today | Display the current date and time
The second is the now function, which displays the current date and time, and the today function, which displays today's date.
By combining these with the dateBetween we can count the number of days until the deadline.
This is a useful way to manage tasks and projects, so be sure to give it a try.
style｜Add color to text
In addition, we will also introduce style functions that you may want to use together.
The style function allows you to arrange the display results of a function, specifying the text and adding color.
In the study group, along with the conditional expressions that will be introduced later,
- 1 day left: Display "1 day left" in red text, red background, and code notation
- 2 days left: Show above in yellow
- 3 days left: Show the above in green
- After that: The above will be displayed in gray.
He demonstrated how to change the style depending on the number of days.
Being able to color code using the style function makes it easier to understand at a glance.
if / ifs | Conditional branch: if ~ then ~
Many people have trouble with Notion's functions, such as the "if" statement, which allows you to set conditions such as "if...then do...".
It's a little complicated to use, but it's a very versatile function.
This time, using the example of a diary, we introduced how to convert the selected mood into a score and then graph it.
The content of the conditional expression is as follows:
- If the mood property is ★★★★★, display it as 10
- If it's ★★★★, it will be displayed as 7
- If it's ★★★, it will be displayed as 5
By converting the scores into numbers, it is now possible to display them graphically.
In addition, we introduced some other useful functions to remember during the study session!
Be sure to check out the Notion Life community at the end of the article.
💬 How to write mathematical formulas in Notion AI
The last feature I explained was the recently released Notion AI feature for writing mathematical formulas.
This is a feature only available with paid plans, but the formula properties now have AI built in, so you can write functions just by giving instructions to the AI!
For example, when we used dateBetween earlier to calculate the number of days remaining until the deadline, the function was automatically written just by providing instructions.
📺Study session archives are now available!
The archive of this Notion Math Study Group is now available on the Life and Notion Community!
By becoming a community member, you will be able to view not only this math study session, but also past Notion study sessions.
We plan to hold study sessions every month, so if you're interested, please check it out here!
By the way, we are planning a Notion calendar study session on November 30th this month.
🔗 Life and Notion Community : https://kurashi-notion.com/pages/community
Click here for a list of Notion templates available on "Life and Notion" !
The book "Notion Life Hacks" is now on sale! It includes 36 templates and provides plenty of practical tips on how to use Notion.
We also introduce how to use Notion and specific examples of its use on YouTube , so please take a look if you're interested.
We will continue to provide information about daily life and Notion to help you get the most out of your busy days.
Thank you for reading to the end!
See you in the next article.
