a year ago
New in models: ISBLANK() for handling blank values
Quickly check for blank values in your model formulas to simplify conditional logic and ensure accurate results.
✨ What's new?
ISBLANK() is now available in models to help you identify blank values in your formulas. This makes conditional logic clearer and ensures blank entries are handled correctly.
⚙️ How it works
Use ISBLANK() within an IF-THEN-ELSE statement to check whether a variable is blank:
IF ISBLANK(VAR) THEN [Result if blank] ELSE [Result if not blank]
- Returns TRUE if the variable has no value
- Returns FALSE if the variable contains any value, including zero
📚 Learn more
For full details and usage guidelines, visit the Academy: Link.