Kepion supports a large number of Excel Functions in our Forms, allowing for the creation of more dynamic and customized content. For example, you can create custom sub-totals in a Form that has a dynamically changing number of rows.
1. Click Edit.
2. Right-click a row header and select either Insert Before or Insert After to create your new static row.
3. In the newly created row you can now enter a spreadsheet formula such as:
This formula directs the spreadsheet to add up the values in the column range (e.g. D to G) and display the sum in the selected cell.
Tip: Static rows are indicated by the * preceding the header label.
For more details, you can find the full list of Excel functions which are supported in Kepion below:
|AVERAGE||=AVERAGE(1; 2; 3)|
|IF||=IF(A1; TRUE; FALSE)|
|VLOOKUP||See Excel online documentation|
|HLOOKUP||See Excel online documentation|