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.
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:
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.
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.
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.
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.”
A formula column with simple math operations that manipulate values from number columns would be already helpful.
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.
I’ve many Notion db with formula, it would be very useful (and indispensable for others around me )
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
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.
I believe Notion can perform all of the tasks I’ve described here.