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
- 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.