Formula
Ask NocoAI
Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.
- Add a formula field that shows how many days are left until [Due Date]
- Add a formula field that calculates [Quantity] times [Unit Price]
- Add a formula field that shows [Overdue] when [Due Date] has passed and [Status] is not [Done]
- Explain what the formula in [field name] does
Create a formula field
- Click the
+icon to the right ofFields header. - In the dropdown modal, enter the field name (Optional).
- In the dropdown, select the field type
Formula. - Enter the formula.
- Click
Save Field.
- You can use explicit numerical values/ strings as needed, e.g.
123(numeric) or"123"(string). - You can reference field names in equation with
{}, e.g.{field name} - Nested formula (formula equation referring to another formula field) is supported
Unlike other field types, formula cells cannot be modified by double-clicking since the value is generated based on the formula.
Supported formula functions
Last updated on
Latest product updates?See Changelog