Help

Trying to add an or condition for the "Completed" status

Topic Labels: Formulas
536 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cipherhunter
4 - Data Explorer
4 - Data Explorer
IF(
AND(
{State (from Government Body)} = 'Iowa',
{Public Records Received (Yes/No)}= 'No',
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 50
),
"Delinquent",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Complaint Submitted to Iowa Public Information Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 60,
"Government Body Failure"
)
)
)
),
IF(
OR(
{Public Records Received (Yes/No)},
{Page Count} = 0;
"Completed"
)
)
)
 
I am teaching myself and/or conditions for a status formula and I am requesting assistance with adding an or condition to the "Completed" section of the code.  The rest functions as desired.  
2 Replies 2
cipherhunter
4 - Data Explorer
4 - Data Explorer

I think I am closer but still not joy.

 

IF(
AND(
{State (from Government Body)} = 'Iowa',
{Public Records Received (Yes/No)}= 'No',
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 50
),
"Delinquent",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Complaint Submitted to Iowa Public Information Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 60,
"Government Body Failure"
)
)
)
),
IF(
OR(
{Public Records Received (Yes/No)},
"Completed"
),
IF(
AND({Page Count} = 0,
{Public Records Received (Yes/No)}='No',
)
"Completed"
)
)
)

It looks like you’re missing a closing parentheses and a comma after {Page Count}=0. You have a semicolon there now.