Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
899 2
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
cipherhunter
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Jul 04, 2023 08:11 PM

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.  
0 Kudos
Reply
2 Replies 2
cipherhunter
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Jul 04, 2023 08:27 PM

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"
)
)
)
0 Kudos
Reply
pressGO_design
10 - Mercury
10 - Mercury
See Solution in Thread

‎Jul 05, 2023 05:39 AM

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

0 Kudos
Reply
Copyright © 2025 Khoros, LLC
Top