A Formula Field does not properly increment number fields inside Vault.
Formula Fields by default are set to Treat blank values as blanks. This causes a field with a blank value to carry the blank value instead of an incremental value.
In order for incrementing to work with a blank field value, the option for Treat blank values as zeros must be enabled. To do so:
- Navigate to the formula field in the Entry Actions menu.
- Press the Calculator button .
- Press Advanced Settings drop-down menu.
- Change the Blank Field Handling option to Treat blank fields as zeros.
Vault Help Documentation: Setting Fields with Formulas
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.