This how-to guide includes 3 topics, all available without membership; use the How-to Index to jump to the task you need and follow the entry point plus steps.

How-to Index

#	Topic	Membership
1	1. Create a formula field and call VALUE	Free
2	2. View and fill in the VALUE argument format	Free
3	3. Use VALUE results in later calculations	Free

How-to Guide

1. Create a formula field and call VALUE

Entry point: Add Field → Formula

Open the DBSheet you want to edit.
Click Add Field on the toolbar.
Select Formula as the field type.
Enter a formula that includes VALUE in the formula editor.
Click Confirm to save the setting.

Success Criteria

UI state: A new formula field appears in the table.
Next actions: You can continue editing the formula or review the calculation result.

Tips While Using

Common mistakes: If you do not choose the Formula field type, you cannot enter a function.
Environment limits: If the online table does not load correctly, check your network and edit permissions first.

2. View and fill in the VALUE argument format

Entry point: Formula Editor → Function Library → VALUE

Open the function library in the formula editor.
Select VALUE to view its format guidance.
Fill in the target argument based on the displayed format.
Check whether the referenced content matches the text data you want to convert.
Save the formula and confirm that it returns a numeric result.

Success Criteria

UI state: The formula editor shows the VALUE syntax.
Next actions: After saving, you can keep adjusting the argument or nest other functions.

Tips While Using

Common mistakes: If the referenced argument is incorrect, the conversion result may not match your expectation.
Environment limits: Different field content formats may behave differently, so test with a small set of records first.

3. Use VALUE results in later calculations

Entry point: Formula result field

Finish the VALUE formula and save it.
Check whether the result is displayed in the current record.
Use the converted result in later calculation logic.
Change the source data and confirm that the result refreshes with the record.

Success Criteria

UI state: The formula field shows a numeric result that can be used in calculations.
Next actions: You can combine it with other functions or continue checking record changes.
No side effects: Editing the formula field does not directly overwrite the original source field.

Tips While Using

Common mistakes: Using text that was not converted successfully in later calculations can cause unexpected results.
Environment limits: Result refresh depends on the table loading normally.