[GH-ISSUE #3878] [FR] Formula support in Grids #1755

Open
opened 2026-03-23 21:16:49 +00:00 by mirror · 12 comments
Owner

Originally created by @jramke on GitHub (Nov 6, 2023).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/3878

Description

I think it'd be a great feature to have a formula property for grids. Maybe this is somehow possible with the already implemented KateX plugin.
With a formula you can for example calculate the time between two dates in a row and use the grid for time tracking.

Impact

Users how use appflowy for work and time tracking jobs

Additional Context

No response

Originally created by @jramke on GitHub (Nov 6, 2023). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/3878 ### Description I think it'd be a great feature to have a formula property for grids. Maybe this is somehow possible with the already implemented KateX plugin. With a formula you can for example calculate the time between two dates in a row and use the grid for time tracking. ### Impact Users how use appflowy for work and time tracking jobs ### Additional Context _No response_
Author
Owner

@annieappflowy commented on GitHub (May 9, 2024):

Formula is what makes the difference in notion and coda, playing with properties is what we need. I'll keep an eye on it and use it in parallel, I really liked the idea, rollups are also missing

<!-- gh-comment-id:2102617058 --> @annieappflowy commented on GitHub (May 9, 2024): Formula is what makes the difference in notion and coda, playing with properties is what we need. I'll keep an eye on it and use it in parallel, I really liked the idea, rollups are also missing
Author
Owner

@amauryfischer commented on GitHub (Aug 30, 2024):

@annieappflowy any news on formula support ? That would be awesome.
I builded a CRM for my company based on Coda capabilities to build advanced formula (also button linked to action, opening modal etc...)
Would love to do that with AppFlowy too

<!-- gh-comment-id:2321137447 --> @amauryfischer commented on GitHub (Aug 30, 2024): @annieappflowy any news on formula support ? That would be awesome. I builded a CRM for my company based on Coda capabilities to build advanced formula (also button linked to action, opening modal etc...) Would love to do that with AppFlowy too
Author
Owner

@MarArMar commented on GitHub (Aug 31, 2024):

This would be a game changer and unlock many use cases indeed

Especially combined with filters you can generally calculate properties like "due soon" and put some entries at the top of your database, or, on the contrary, hide properties you do not need

Tracking this FR

<!-- gh-comment-id:2322824066 --> @MarArMar commented on GitHub (Aug 31, 2024): This would be a game changer and unlock many use cases indeed Especially combined with filters you can generally calculate properties like "due soon" and put some entries at the top of your database, or, on the contrary, hide properties you do not need Tracking this FR
Author
Owner

@beginner1393 commented on GitHub (Dec 18, 2024):

I was wondering if there’s any progress or updates regarding formula support in grids? This feature would be incredibly important and highly useful. It’s something many users could benefit from and would make AppFlowy much more versatile.

Looking forward to hearing more about this!

<!-- gh-comment-id:2550586508 --> @beginner1393 commented on GitHub (Dec 18, 2024): I was wondering if there’s any progress or updates regarding formula support in grids? This feature would be incredibly important and highly useful. It’s something many users could benefit from and would make AppFlowy much more versatile. Looking forward to hearing more about this!
Author
Owner

@PodyNoo commented on GitHub (Dec 18, 2024):

This is the last thing i'm waiting to migrate from OneNote to AppFlowy (i'm currently using formulas with OneMore addin in OneNote)

<!-- gh-comment-id:2550615920 --> @PodyNoo commented on GitHub (Dec 18, 2024): This is the last thing i'm waiting to migrate from OneNote to AppFlowy (i'm currently using formulas with OneMore addin in OneNote)
Author
Owner

@beginner1393 commented on GitHub (Jan 17, 2025):

I previously posted about this, and I’d like to ask again if this feature is currently under development. Is it planned to be implemented in the future?

<!-- gh-comment-id:2597599169 --> @beginner1393 commented on GitHub (Jan 17, 2025): I previously posted about this, and I’d like to ask again if this feature is currently under development. Is it planned to be implemented in the future?
Author
Owner

@SchneckchenAndy commented on GitHub (Aug 4, 2025):

Would be fantastic in order to finally migrate all Grids from Notion to Appflowy 👍

<!-- gh-comment-id:3150708708 --> @SchneckchenAndy commented on GitHub (Aug 4, 2025): Would be fantastic in order to finally migrate all Grids from Notion to Appflowy 👍
Author
Owner

@amauryfischer commented on GitHub (Aug 13, 2025):

@annieappflowy any news about this ? : D

<!-- gh-comment-id:3184379048 --> @amauryfischer commented on GitHub (Aug 13, 2025): @annieappflowy any news about this ? : D
Author
Owner

@GoLLuM-G13 commented on GitHub (Oct 30, 2025):

I wanted to try (and like this app) but the lack of formula is a dealbreaker. That's too bad, but until then, I'm going back to Notion

<!-- gh-comment-id:3465872960 --> @GoLLuM-G13 commented on GitHub (Oct 30, 2025): I wanted to try (and like this app) but the lack of formula is a dealbreaker. That's too bad, but until then, I'm going back to Notion
Author
Owner

@D1reW0lf commented on GitHub (Jan 14, 2026):

Hi.
Since I can't seem to find a way to vote for features, I just want to add my me too to this.

<!-- gh-comment-id:3747997300 --> @D1reW0lf commented on GitHub (Jan 14, 2026): Hi. Since I can't seem to find a way to vote for features, I just want to add my _me too_ to this.
Author
Owner

@PinkNinjaa commented on GitHub (Feb 4, 2026):

The database formulas is what is chaining me to notion (that and more views for databases).I use it for a bunch of things- like a recipe database with dynamic serving adjustments. Or simply keeping track of finances- if this was added I would happily drop my ungodly priced notion subscription and finally be a notion refugee

<!-- gh-comment-id:3844949528 --> @PinkNinjaa commented on GitHub (Feb 4, 2026): The database formulas is what is chaining me to notion (that and more views for databases).I use it for a bunch of things- like a recipe database with dynamic serving adjustments. Or simply keeping track of finances- if this was added I would happily drop my ungodly priced notion subscription and finally be a notion refugee
Author
Owner

@JoverZhang commented on GitHub (Feb 20, 2026):

Hi AppFlowy folks — I’m prototyping a Notion-style formula toolchain in Rust (editor UX first: diagnostics/formatting + completion/signature help), packaged as WASM for embedding.

Demo: https://www.jovers.org/notion-formula-rs
Repo: https://github.com/JoverZhang/notion-formula-rs

Small question: Is there already an active formula MVP plan for Grids? If so, I’d love to align.
To help me scope an MVP, could you share:

  1. The top 3–5 field types you most want formulas to support first
    (e.g. Text / Number / Date / Checkbox / Select / Relation)

  2. The top 5–10 functions you need first (optional, but helpful)
    (e.g. if/ifs, boolean ops, concat, empty, now/today, sum/avg)

(Optional) 1–2 MVP examples in this format:

  • Fields: Status(Select), Points(Number)
  • Formula: if(Status == "Done", Points, 0)
  • Example:
    • Status="Done", Points=3 -> 3
    • Status="Todo", Points=3 -> 0

If you can try the demo for 2 minutes, feedback is very welcome.
Please share: formula + expected vs actual (esp. completion/signature help/diagnostics/formatting).

<!-- gh-comment-id:3936022549 --> @JoverZhang commented on GitHub (Feb 20, 2026): Hi AppFlowy folks — I’m prototyping a Notion-style formula toolchain in Rust (editor UX first: diagnostics/formatting + completion/signature help), packaged as WASM for embedding. Demo: https://www.jovers.org/notion-formula-rs Repo: https://github.com/JoverZhang/notion-formula-rs Small question: Is there already an active formula MVP plan for Grids? If so, I’d love to align. To help me scope an MVP, could you share: 1) The top 3–5 field types you most want formulas to support first (e.g. Text / Number / Date / Checkbox / Select / Relation) 2) The top 5–10 functions you need first (optional, but helpful) (e.g. if/ifs, boolean ops, concat, empty, now/today, sum/avg) (Optional) 1–2 MVP examples in this format: - Fields: Status(Select), Points(Number) - Formula: `if(Status == "Done", Points, 0)` - Example: - Status="Done", Points=3 -> `3` - Status="Todo", Points=3 -> `0` If you can try the demo for 2 minutes, feedback is very welcome. Please share: formula + expected vs actual (esp. completion/signature help/diagnostics/formatting).
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AppFlowy-IO/AppFlowy#1755
No description provided.