What can you calculate?
Compare dates
IS_BEFORE and IS_AFTER compare two dates and return true or false. For example, IS_BEFORE({StartDate}, {EndDate}) is true when the first date is before the second. IS_AFTER({ShipDate}, {DueDate}) is true when the first date is after the second.
If either date is blank, the result is false.
Formulas can’t use today’s dateFormulas don’t support
NOW() or TODAY(). Formula values are stored and only update when that record changes, so a value based on today’s date would go out of date.If you use NOW() or TODAY(), you’ll see: “NOW() and TODAY() aren’t supported in formulas, because formula values are stored and would go stale. Compare against the current date in app code instead, or use a scheduled automation to act when a date passes.” The words NOW and TODAY in text or a field name are still fine.To show something like an “Overdue” badge or days until a due date, ask Zite to show it in the app. The app compares the date with today when the page loads. To send a reminder or change a status when a date passes, use a scheduled workflow.Create a formula
1
Add the field
Select Add field → Formula. Enter a clear Title, such as Order total.
2
Describe the calculation
Select Generate with AI and describe the result you need using your exact field names. For example:
Multiply Quantity by Unit price. If either field is empty, leave the result blank.Select Generate. Zite places the generated formula in the editor for you to review.
3
Create and check the result
Select Create. Check a few records, including one with an empty input, to make sure the calculation behaves as expected.Open Edit field to adjust it later. Where available, use Formatting to change how numbers, currencies, percentages, or dates appear.

Use your field names and explain what should happen when information is missing.
Choose the right field
- Formula: Calculate or format a result using a rule.
- Lookup: Show a value from a linked record, such as a customer’s email.
- Rollup: Summarize linked records, such as the total value of a customer’s orders.
- AI field: Interpret or generate content, such as a summary of meeting notes.
A formula returns a value. It doesn’t send a message or change another record. Use a workflow when you want an action to happen.