Help

Calculate if field is full, skip if blank

Topic Labels: Formulas
Solved
Jump to Solution
3483 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah_Turkus
4 - Data Explorer
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

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