I want this really bad. I use the formula field a crap-ton in Notion for some really awesome dynamic views. I would kill to have this here.
Hi Everyone
Please be aware
Many comments express the desire to implement this feature soon, where I share the same opinion as you and wish it. But I would like to remind you to also describe your use cases as @ignatovv & @Dragos says:
[quote="ignatovv, post:23, topic:1554“]
Can you please share how do you use this feature in your life?
[/quote]
[quote="Dragos, post:30, topic:1554“]
If you would like to see it happen, please continue engaging and making a case for the utility so that my fellow colleagues can see the potential and community support 
[/quote]
So @lolfert , @Yann , @luiso , @otibmit, @mavka and @lousytrybrian please name your specific use cases for this feature. So that the developers can see the importance of this feature for the community.
My Use cases:
As @arminta7 said:
-
Tracking the various measurable things to see its development/trend.
Health: tracking habits, body weight, training, diary, etc.
Wealth: finances, trading, budgets & taxes etc. -
In a further step: To visualize my progress of my goals and projects etc. in form of progress bars or different kind of charts.
Hope:
I hope that with my post this feature gets more attention and can possibly be tackled a little earlier.
Why don’t I see this on the roadmap?
This is by far the most requested feature.
For my use case I like to track daily stats. In Notion a day view will look like this:
These are all formulas that pull from the other properties and makes this really cool view (this is Board view) that is dynamic based on the information I enter in to the properties. The movies/tv shows, books, and locations are relations pulling from another database.
One of these fields would look like this in a formula property:
if(prop(“Watched”) == “”, “
I didn’t watch anything today.”, “ I watched " + prop(“Watched”) + " today.”)
I also like to use the formatDate formula to extract the time from the Date&Time, but Anytype doesn’t support time with the date (which stinks…).
And then I used to use a formula I got from Red Gregory that was a progress bar (before Notion officially supported progress bars, which Anytype should steal) for showing book progress.
That’s a few use cases for me.
Not on my screen. 
Calendar is still the most voted one, and formulas might even fall to third place soon.
Iirc, the Anyteam should be soon deciding on what they want to prioritize in the last 2 quarters, so if they decide to work on it, it’ll appear on the roadmap soon.
But if I also remember correctly, there were some technical and architectural issues that need to first be resolved before they can even start working on formulas. This was mentioned long ago, so maybe this isn’t an issue anymore.
Very cool and practical summary of your day 
.
And the fact that it’s dynamic is well thought out. 
Hi, I’m two days into Anytype, first post.
I’ve been using Coda for a while, mainly as a repository for reference data that I need to build for another system (its ability to build tables in a document and then be able to cut and paste is great) Anytype fulfils my desire not to be dependent on hosted services.
In my playing around I used the document safe box example from YouTube and tried building an object for drivers licences, so that’s my simplistic use case.
I have three drivers licences and my partner has two. So my object looks like
Licence.Human, Licence.Issuer, Licence.ExpiryDate, Licence.Name
To show these in a set I am compelled to use the Licence.Name field.
Licence.Name should be computed from Licence.Human.Name + Licence.Issuer.Name otherwise I have to type the Licence.Name field and make it something meaningful.
This is just my simple example, but pretty much any object that is a compound of other objects of different ownership and different issuer are probably going to be the same. I suppose I could use the licence number as the name, but then I’ve got a label title that doesn’t equate to what the contents are and also it won’t be very descriptive if I use that somewhere else.
So the ability to make relations computed based on the contents of other relations,
Would be very helpful if the databases has a formula column to allow simple math operations or text generation with concatenated content.
USE CASES
A formula column that takes an anual cost value (a number from another column) and divide it to have the monthly cost from something.
A formula column that takes the start date from column A and the end date from column B to indicate a duration, for example, from a project.
A formula column with an “IF” statement where you could return a message. “IF” column A contains “DONE”, than write “The project is concluded.”
SIMPLER APPROACH
A formula column with simple math operations that manipulate values from number columns would be already helpful.
REFERENCES
Notion and Coda.io both have formula columns, but if you need to take good inspiration, take a look at what Coda.io did. They design a whole system around formula columns and brought it even to the canvas, where you can create formulas in the middle of texts and you can create really complex systems from it.
+1!
I’ve many Notion db with formula, it would be very useful (and indispensable for others around me )
USE CASES
-
Concatenate field
A database of software (or photos or anything else), you want a gallery with the sofware name and and the type in brackets. Or book title and author. Or…
A concatenation formula is the trick that makes this possible on Notion. And as Anytype galleries have the same limitation (no formatting option for displayed relations), this will also be useful.
Here “Use : Wiki, …” is a formula with concatenation (sorry, haven’t add Anytype yet
)
-
Date calculation: I have a travel diary with dates that can vary… typically the timetable for the plane! If this schedule changes, the whole schedule updates itself as the following dates (arrival time, car pick-up, accommodation arrival, etc.) are calculated
-
Quantity calculation
I have recipes (meals but also products such as soaps, etc.) with quantities to respect. All I have to do is change the “total quantity” value so that the calculated columns for the quantities of each item are updated. Quick and efficient!
I dont get why so few people upvote this and I dont get why this isnt a priority since the beginning. What do u want to do with a database full of numbers? Just look at them and sort it? 
Simple math first, complicated formulas later - coda solved it better than notion.
I just found out about Anytype and love the mission and vibe!
Related solution request
I am a professional video editor and want to keep track of the business I do.
Each project I work on would be an object with related budgets, number of days worked, hard costs I have to pass on, a commission percentage, etc. (Projects would also have many Humans and resulting pieces of created related as objects which I think Anytype would be great at doing).
Solution I’d like
I’d like formulas to be able to calculate my profitability on each job, average per day worked, etc. As well as perform calculations across multiple job-objects to judge performance over time. I’d like to view these calculations in a table format in individual cells, in footer rows of columns as was well as have each formula result able to be added to a dashboard.
Alternatives Considered
I believe Notion can perform all of the tasks I’ve described here.
Now that Calendar view has shipped, this is the most voted FR. Any updates?
WHAT DO YOU RECOMMEND
Enable the entry of a formula in a field to generate a calculated or derived value to be stored in the field.
HOW COULD IT BE DONE
In fields where a typed value can be entered, the editor could support entry of a syntax that is interpreted to yield a value to be stored in the field. The syntax would support the concatenation of the values stored in objects, blocks or relations, other string manipulations, arithmetic or date calculations, or other indirect value references.
REAL WORLD USE CASES
One of many example use cases: The title field of an object is often derived from the values of that object’s relations, as in the case of a CRM contact person object that contains the relations FirstName, MiddleName and LastName and the object is given a title consisting of “FirstNameLastName.” Under present functionality, the same data is typed into the object twice, and if the values in the relations are ever updated, a manual update of the title must also be made. If the object title contains a formula to concatenate the value of two fields separated by a space, the data is entered only once. If the formula can be specified in a template for that object type, even the formula is only entered once in the template, and every object created with that template has the value of the title field calculated without re-entry of the formula.
RECOMMENDED ALTERNATIVES
None.
ADDITIONAL CONTEXT
A robust implementation of such functionality is demonstrated in the Airtable web app. I am seeking to implement in Anytype a CRM/Sales Management system that, in relational database terms, includes multiple tables of customer information and transaction records with one-to-many relationships between the records of separate tables.
Same question.
Please, is it planned or is it “a day pehaps”?
If not planned or “a day”, I’d use Notion without question for the time being .
Anyway, I’d like to migrate from Evernote before that
This is so essential that I was surprised it wasn’t already supported. Some of the ways I’ve used it in Notion:
- progress bars, like percentage of completed tasks within an epic
- formatting raw columns into display columns
- date manipulation (like calculating next due date based on last done date)
- converting dates to durations (which update dynamically with a now() value)
- combining multiple columns into a single score value
- combining multiple columns into a single column that can then be used to filter a view
- unit conversions (F to C, in to cm, etc)
- and of course, simple accounting calculations
Really opens things up. This and support for Mermaid.js are my biggest reasons I can’t move from Notion yet.
Still curious here
first the formula must be the same as notion’s formulas it really helps to filter certain things without much effort
WHAT DO YOU RECOMMEND
Make it simple and add instructions for new users
HOW COULD IT BE DONE
I don’t know but you can see how notion made it and do it better
REAL WORLD USE CASES
ok sometimes I need a formula to calculate the time between today and the due date which is very helpful and also i use it to process my tasks through some filters with the formulas and also I can make a progress bar with it so I can see a visual indicator for my progress in stuff and more and more and more it’s a very powerful tool to organize your life even more
RECOMMENDED ALTERNATIVES
I don’t know actually it’s a very complicated feature but it’s based mainly on programming so if there are any way to add a programming language that anytype would understand it’s gonna work well
ADDITIONAL CONTEXT
ok I also need progress bars so I can see my visual progress on goals
and may be some integrations would be soooo great specially with a calender app for time blocking
but guys, if are able to add time blocking to your app locally it’s gonna be the greatest app ever
again ADD TIME BLOCKING TO THE APP IT’S THE GREATEST FEATURE SINCE NOONE ELSE HAS MADE IT BEFORE any other app just integrate with google calendar or so but if you implemented your own type of calendars that make time blocking that’s great ok you will be famous fast that way since a lot of people need that specially me and keep it local and offline never give up on that , that is what keeps you the best in my opinion
Blockquote
i just want to be able to make simple calculations inside tables