christian/waters-boards
1
0
Fork 0
Code Issues 9 Pull Requests Actions Packages Projects Releases Wiki Activity

Formula column #4

New Issue
Open
opened 2026-10-19 14:00:32 -04:00 by michael · 0 comments
michael commented 2026-10-19 14:00:32 -04:00
Owner
Copy Link
Copy Source

A column type whose value is calculated from other columns on the same item.

Why: in monday.com, some "AI" automations are really just arithmetic. A formula column replaces them with something exact and free:

  • Buy List: quantity × price.
  • Subscriptions Inventory: monthly or yearly cost, depending on which group the item is in.

monday.com formula columns, such as those on the WS and NA Production Inventory boards, currently import as plain text frozen at the value they had on import day.

Scope

  • Operations: arithmetic, rounding, comparisons and IF. Also differences between dates, joining text, and the item's group name.
  • Safety: a small expression parser, never eval.
  • Errors: a broken formula shows an error in the cell instead of crashing the board.
  • Summaries: group footers summarize formula values like number columns do.

Later, optional: have the monday.com importer convert monday formulas where the syntax maps cleanly.

A column type whose value is calculated from other columns on the same item. **Why:** in monday.com, some "AI" automations are really just arithmetic. A formula column replaces them with something exact and free: - **Buy List:** quantity × price. - **Subscriptions Inventory:** monthly or yearly cost, depending on which group the item is in. monday.com formula columns, such as those on the WS and NA Production Inventory boards, currently import as plain text frozen at the value they had on import day. **Scope** - **Operations:** arithmetic, rounding, comparisons and IF. Also differences between dates, joining text, and the item's group name. - **Safety:** a small expression parser, never `eval`. - **Errors:** a broken formula shows an error in the cell instead of crashing the board. - **Summaries:** group footers summarize formula values like number columns do. **Later, optional:** have the monday.com importer convert monday formulas where the syntax maps cleanly.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
michael (Michael McGary) christian
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: christian/waters-boards#4