Using Formulas for Calculations in Spreadsheet Blocks
Apply formulas in your Spreadsheet Block to quickly calculate totals, averages, percentages, and other values without manual entry.
Using Formulas for Calculations in Spreadsheet Blocks — FAQ
Do formulas update automatically if data changes
Yes. When you edit values in your spreadsheet, formulas like SUM, AVERAGE, MIN, and MAX automatically recalculate the updated result.
Why is my formula working?
Formulas only work on numeric values. If any selected cell contains text, special characters, or blank text fields, your formula may return an error.
What formulas can I use for quick calculations?
You can use basic functions such as SUM, AVERAGE, MIN, and MAX to perform fast and accurate calculations on selected numbers.