Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Calculate if field is full, skip if blank

Topic Labels: Formulas
Solved
Jump to Solution
495 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Yes there is:

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

See Solution in Thread

3 Replies 3

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

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