Formula columns

Formula column support in Client Portal Builder

Support for native formula columns in the Client Portal Builder is considered experimental. The team at monday.com has added support for formula columns to their API recently, but with certain restrictions. They "only" support calculating up to 10,000 formulas per minute, and they officially support only up to 5 formula columns per board (although our tests indicate this restriction wasn't strictly enforced). They also do not support formulas containing mirror columns. Please be aware that all formula results are treated as string, even numbers.

Potential issues and limitations

Enabling formulas Calculated values are returned by the monday API as text.
Potential issues Visibility is not assured if more than 10,000 formula values are calculated per minute, counted across different boards and all clients.
Column limit Visibility is not assured if one board has more than 5 formula columns enabled.
Formula restrictions Does not support Mirror Columns or Subitems in formulas.

Example: Formula value counting

If you have a board in your Client Portal with 4 formula columns and this board has 100 items (after filters have been applied), then 400 formula values need to be calculated (4 * 100). The total number of formula columns on the board will be used in the calculation, regardless of how many of those columns you use in the Client Portal.