FAQ
FAQ
If you notice that a field value keeps "disappearing" or "changing" unexpectedly, it may be caused by automated processes you have set up, such as Formulas, Default Values, Link and Load, or Periodic Imports, which might be interacting in ways you did not intend. We recommend checking the Entry Information to identify what triggered the update and address the issue accordingly.
The following are common examples for your reference.
Example:
You’re using Multiple Versions of a sheet to create quotes in different currencies.
In the USD version, the "Amount Due" field uses a formula based on U.S. tax rules.
In the EUR version, the same field (with the same Field ID) uses a formula based on European VAT rates.
If a quote created in USD is later edited in the EUR version, and the formula is triggered again, the value based on U.S. tax rules will be overwritten by the result calculated using the European formula.
If a field is configured to auto-fill (e.g., via a Formula or Link and Load) and you also enter values manually, your manual input may be overwritten when automation is triggered, such as during Formula Recalculation or when Keeping loaded value sync with source.
Example:
In a "Salary Calculation" sheet, the "Hourly Rate" field is calculated using a formula.
However, you manually override the value for a specific record to handle a special case. Later, if the formula is recalculated, your manual value will be overwritten by the formula result.
Example:
In a "Salary Calculation" sheet, the "Hourly Rate" field is designed to load values from a linked sheet such as a "Salary Reference Table". However, you forget about this setup and manually enter the values instead. Later, you enable the "Keep loaded values synced with the source" option to ensure the data stays updated. Since the corresponding field in the source sheet is "Empty", that empty value gets synced and overwrites your manually entered data.
If field updates are due to your sheet setup, be sure to correct the data and improve the design logic. Here are some suggestions:
1. Avoiding Applying Different Formulas to the Same Field Across Multiple Versions
It is recommended to set Fixed Filters or use separate fields for different versions to prevent data from being overwritten when switching versions or when formulas are unintentionally triggered.
2. Managing Conflicts Between Manual Input and Auto-Fill
If a field is sometimes filled manually and sometimes automatically, avoid applying a universal formula. Instead, use the UPDATEIF formula to update the value only when specific conditions are met.
Preventing Issues Caused by Empty Values
Don’t ignore "Empty" Loaded or Imported fields, as they can overwrite existing data. You can disable unnecessary loaded fields in Link Manager and select "Ignore" for unwanted fields during import.
Avoiding Incorrect Changes to Field Types
For example, if your field value was originally "12345" but you changed the Field Type to a Date field, it will appear empty because the value does not match the required format. Similarly, if you change the field type to Select From Other Sheet but the linked sheet does not contain the value "12345", it will also appear empty, similar to selecting a non-existent option from a dropdown. If you have not made any further changes, simply revert the field type to the original, and the values will return to normal. For more details, please refer to this article.
If a value was unintentionally updated due to a Formula or Link and Load sync, please refer to this article for steps to recover the original data.
