In a number formula, is there anyway to default to [empty] if the formula’s conditions are not met? For this specific field, there are some entities that this formula doesn’t apply to. But I don’t want the field to say “0%”. I just want the field to be blank. I know I could technically convert it t…

Can a number formula return nothing instead of zero?

Matt_Blais June 6, 2024, 9:14pm 2

11 votes!

1 Like

Topic		Replies	Views
Allow to return an empty value from a formula Ideas & Features formulas	26	1352	March 10, 2026
Formula 'Generate using AI' keeps on using 'null' Bugs & Issues automations , formulas , ai	1	50	August 1, 2025
If condition: how to return nothing when the returned type is an entity? Get Help formulas	4	476	January 27, 2022
Formula-generated values only if field is empty Ideas & Features	2	21	February 8, 2026
Return "no-entity" from a formula Get Help	7	426	March 23, 2023