Skip empty field in formula

[Sarah_Turkus]

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’)

[Jeremy_Oglesby]

Hi @Sarah_Turkus,

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},
   DATEADD(
      {Field Date 1},
      {Days b/w successions},
      'days'
   )
)

[Sarah_Turkus]

That worked great, thank you!

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

[Jeremy_Oglesby · Accepted solution]

Yes there is:

IF(
   AND({Days b/w successions}, {# successions} = 3),
   DATEADD(
      {Field Date 1},
      {Days b/w successions},
      'days'
   )
)