# Calculate if field is full, skip if blank

Topic Labels: Formulas
Solved
3133 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi! Very new to formulas and slogging my way through thanks to all the great advice in this forum!

I’m trying to get the formula to return nothing if {days b/w successions} is blank, and to calculate the next date if there is a number in that field.
I wrote this, based off what I gleaned from other posts, but it isn’t working.

IF({Days b/w successions}=BLANK()," ", DATEADD({Field Date 1},{Days b/w successions}, ‘days’)

1 Solution

Accepted Solutions
14 - Jupiter

Yes there is:

``````IF(
AND({Days b/w successions}, {# successions} = 3),
{Field Date 1},
{Days b/w successions},
'days'
)
)
``````
3 Replies 3
14 - Jupiter

The easiest way to get a conditional formula to return “nothing” in the case that the field being checked is empty is to only supply a success condition. In your case, it would look like this:

``````IF(
{Days b/w successions},
{Field Date 1},
{Days b/w successions},
'days'
)
)``````
4 - Data Explorer

That worked great, thank you!

Is there a way to add another layer?
If the {# successions} is 3, then calculate, and if not, skip?

14 - Jupiter

Yes there is:

``````IF(
AND({Days b/w successions}, {# successions} = 3),