With Sheetgo Forms, you can combine various configurations to ensure that your forms are always submitted with the right data. But it doesn't stop there, you can also use familiar spreadsheet and mathematical functions to perform calculations directly within the form, improving efficiency and accuracy in data entry.
Supported functions
You can use this feature to combine basic spreadsheet functions like:
SUM: Adds values.
AVERAGE: Calculates the mean.
COUNT: Counts numeric fields, excluding text.
COUNTA: Counts non-empty fields.
MAX: Finds the highest value.
MIN: Identifies the lowest value.
Additionally, you can use simple mathematical symbols like + (addition), - (subtraction), * (multiplication), and / (division).
To create a dynamically calculated field, use the formula configuration followed by the formula expression. To refer to another field, use its name enclosed in single or double quotes.
Here are some examples of expressions you can use:
[formula: "headerTitle1" + "headerTitle2"]
[formula: "headerTitle1" - "headerTitle2"]
[formula: "headerTitle1" * "headerTitle2"]
[formula: "headerTitle1" / "headerTitle2"]
[formula: ("headerTitle1" / "headerTitle2") * 100]
[formula: ("headerTitle1" * "headerTitle2") / "headerTitle3"]
[formula: SUM("headerTitle1", "headerTitle2")]
[formula: COUNT("headerTitle1", "headerTitle2", "headerTitle3")]
[formula: SUM("headerTitle1", "headerTitle2", "headerTitle3") / "headerTitle1"]
Purchase order example
This feature can be extremely useful in a Purchase Order form, where you have fields for the price and quantity of an item..
On the spreadsheet, the header configuration will look similar to the one above. In this case, the Total Cost field can be calculated by multiplying the value in the Price per order field by the Amount of orders.
The final result on the form will show the calculated total cost. If the locked configuration is used, the user cannot change the "Total" field.
Note: If [locked] is not used, the field will be open for user input.
Error messages
Errors in the field or calculation are presented in the same way as in a spreadsheet. This allows users familiar with spreadsheets to easily troubleshoot their forms.
#VALUE!: invalid values will produce.#NAME!: unsupported or wrong formula names.#REF!: self-references.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.