Help

2 If Statements, 1 is IF/AND Help

Topic Labels: Formulas
Solved
Jump to Solution
204 2
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreaR
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there and Happy Friday!

I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.

The formula I have is essentially, "If the individual does not have a preexisting number, calculate the time difference between the date they got the number and the date they enrolled in the program."

 

The formula is: IF({LO has FTN at time of Enrollment}="No",WORKDAY_DIFF({Enrollment Date},{Turned in FTN}))

 

That works but if “Turned in FTN” is blank, the calculation results in "#ERROR" and I hate "#ERROR".

 

So, that means I need to add something like, “If “Turned in FTN” = Blank, then “””. I tried adding that a few different ways but am still getting #ERROR.

 

Any ideas how to get rid of the #ERROR? Thanks in advance!

 

 

1 Solution

Accepted Solutions
AndreaR
5 - Automation Enthusiast
5 - Automation Enthusiast

figured it out - nested if statement with the blank one first

See Solution in Thread

2 Replies 2
AndreaR
5 - Automation Enthusiast
5 - Automation Enthusiast

PS - The enrollment date is a lookup

AndreaR
5 - Automation Enthusiast
5 - Automation Enthusiast

figured it out - nested if statement with the blank one first