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	21	1103	May 12, 2025
Formula 'Generate using AI' keeps on using 'null' Bugs & Issues automations , formulas , ai	1	37	August 1, 2025
If condition: how to return nothing when the returned type is an entity? Get Help formulas	4	469	January 27, 2022
Return "no-entity" from a formula Get Help	7	398	March 23, 2023
"Enter text" appears in Formula field [FIXED] Bugs & Issues formulas	2	319	November 15, 2022