Author: Kepion Product Team
Kepion supports a large number of Excel Functions in formulas, allowing for the creation of more dynamic content. For example, you can create custom sub-totals in a Form that has a dynamically changing number of rows.
Insert a static row in the Form near the top by right-clicking on a row header. Choose either the option Insert Before or Insert After to create your new static row.
In the newly created row you can now enter a spreadsheet formula such as:
This formula directs the spreadsheet to sum the values in the column range to the current cell.
Tip: You can tell which rows and columns are static by noticing the ‘ indicator preceding the header label.
Finally, give the row some formatting and now you have custom sub-totals in a Form!
For more details, below you can find the full list of Excel functions which are supported in Kepion:
|AVERAGE||=AVERAGE(1; 2; 3)|
|IF||=IF(A1; TRUE; FALSE)|
|VLOOKUP||See Excel online documentation|
|HLOOKUP||See Excel online documentation|