DiligenceVault supports a wide range of calculated cells and validations and rounding options for grid-type questions. Adding in these calculated cells saves time and ensures the accuracy of the data being collected.
To start using grid validations:
- Navigate to "Diligence" > "Templates"
- Select a template and then click Edit
- In the Edit page, you can add a new table type question by clicking the ‘+’ sign or locate your existing table type question in your current template
- Click on the ‘fx’ icon next to the relevant question
5. Click on the links in the help text for formulas supported on the platform and access the FAQs to better understand how the functionality works
List of Errors
A handful of errors can appear in a cell when a formula is applied and cannot be resolved. Please find the list of most common errors below:
| Error | Meaning |
| #DIV/0! | Trying to divide by 0 |
| #N/A! | A formula or a function inside a formula cannot find the reference value |
| #NAME? | Text in the formula is not recognized |
| #NULL! | A space was used in formulas that reference multiple ranges; a comma separates range references |
| #NUM! | A formula has invalid numeric data for the type of operation |
| #REF! | A reference is invalid |
| #VALUE! | The wrong type of operand or function argument is used |
| #ERROR! | It indicates that there is an unknown error in a formula. |
For more examples, please refer to our FAQ on the platform or the video below.