Calculate if field is full, skip if blank

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

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'
   )
)
1 Like

That worked great, thank you!

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

Yes there is:

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

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.