Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
888 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.