User Manual

01.13.2026

MANUAL

Manage Table: Formula

## Overview Set the formula using arithmetic operations and dedicated functions. The formula works when a table is added, changed, or deleted. ## Calculation Method You can select the following as the calculation method. ![image](https://pleasanter.org/binaries/32e4c9b859b84cb29d19808071357d75) 1. Default Perform arithmetic operations on the numerical value column. Date calculations and function specifications are not possible. For details, refer to 「Manage Table: Formula (Default)」. 1. Extension In addition to the Numerical value column, you can set formulas for class columns, date columns, description columns, and check columns. In addition to arithmetic operations, you can use dedicated functions. For details, refer to [Manage Table: Formula (Extended)](/en/manual/table-management-formula-extended). ## When Conditions Are Met / Not Met When a table has views, a condition dropdown will be displayed. If you select a view as a condition, the formula will execute when the view's filter conditions are met, and the "when conditions are not met" case will execute when the view's filter conditions are not satisfied. ![image](https://pleasanter.org/binaries/a477afcb55a9461784d1fe8df54f5faa) ## Disabled You can disable created formulas without deleting them. ![image](https://pleasanter.org/binaries/1ba94b0235a74e06ace024c552bae173) ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-formula-default">Manage Table: Formulas (Default)</a><span>01.13.2026 up</span></li> <li><a href="/en/manual/table-management-formula-extended">Manage Table: Formula (Extended)</a><span>10.03.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP