User Manual

01.13.2026

MANUAL

Manage Table: Formula

The Japanese version of the manual is the latest.
Please also check.
## 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="" />
support_agent 本格運用を、もっと安心・安全に

安定運用や活用拡大を見据えるなら、年間サポートサービスをご活用ください。

年間サポートサービスの詳細はこちら →
school プリザンターを使いこなす近道はこちら

基本から実践まで、プリザンターをしっかり学べるトレーニングをご用意しています。

トレーニングサービスの詳細はこちら →
TOP