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’)
Best answer by Jeremy_Oglesby
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'
)
)
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'
)
)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?
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'
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.