Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Requesting Assistance with Formula for Status Fiel...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

Solved

Jump to Solution

0
1625
7

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 10:11 AM

Requesting assistance with the following formula I am unable to get to function properly.

IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}<=20, {Document Received}=BLANK(),"Pending")

(IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}>20, {Proof of Service (Differential - Proof of Service+(x)Days)}<50, {Document Received}=BLANK(),"Delinquent"),

(IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}>50, {Proof of Service (Differential - Proof of Service+(x)Days)}<60, {Document Received}=BLANK(),"Submit Complaint to Review Board"))))))

Objective:

If (Differential - Proof of Service+(x)Days)}<=20 and State="Florida" and {Document Received} attachment field is empty, fill the formula field with "Pending Document"

If (Differential - Proof of Service+(x)Days)>20 but <50 and State="Florida" and {Documents Received} attachment field is empty, fill the formula field with "Delinquent Document"

If (Differential - Proof of Service+(x)Days)>50 but <60 and State="Florida" and {Documents Received} attachment field is empty, fill the formula field with "Submit Complaint to Review Board"

If (Differential - Proof of Service+(x)Days)>60 and State="Florida" and {Documents Received} attachment field is empty, fill the formula field with "Document Failure"

If {Document Received} attachment field has attachment = "Complete"

Any assistance is greatly appreciated with getting this formula to work that will produce a Status Field.

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 11:35 AM

Hey @cipherhunter!

Don't have time to test this right now, but give this a shot and lemme know if this works for you:

```
IF(
AND(
{State} = "Florida",
NOT({Document Received}),
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 50
),
"Delinquent Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Submit Complaint to Review Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60,
"Document Failure"
)
)
)
),
IF(
{Docuemnt Received},
"Complete"
)
)
```

Reply

7 Replies 7

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 11:35 AM

Hey @cipherhunter!

Don't have time to test this right now, but give this a shot and lemme know if this works for you:

```
IF(
AND(
{State} = "Florida",
NOT({Document Received}),
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 50
),
"Delinquent Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Submit Complaint to Review Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60,
"Document Failure"
)
)
)
),
IF(
{Docuemnt Received},
"Complete"
)
)
```

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 11:54 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 12:17 PM

I’m currently away from a computer, so I can’t test it out myself, so any additional information you can provide about the error would be helpful!

Regarding the field type: no, in this specific scenario, the attachment field type shouldn’t have an effect on whether the formula works or not. The formula simply checks to see if the attachment field returns any data, regardless of the underlying data type.

I would recommend checking the formula syntax to make sure I didn’t forget a comma or misplace a parentheses somewhere.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 12:32 PM - edited Jun 11, 2023 12:33 PM

```
IF(
AND(
{State} = "Florida",
NOT({Document Received Formula} = 'Yes'),
{Proof of Service (Differential - Proof of Service+(x)Days)}
),
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} <= 20,
"Pending Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 20,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 50
),
"Delinquent Document",
IF(
AND(
{Proof of Service (Differential - Proof of Service+(x)Days)} > 50,
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60
),
"Submit Complaint to Review Board",
IF(
{Proof of Service (Differential - Proof of Service+(x)Days)} < 60,
"Document Failure"
)
)
)
),
IF(
{Docuemnt Received Formula},
"Complete"
)
)
I added a {Docuemnt Received Formula} that provides a yes or no on whether the Document Received field has a document in its attachment field. If the attachment field has an attachment(s) status should change to Complete. Still not able to get the formula to work. Any Assistance is greatly appreciated.
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 02:52 PM

Is *{Proof of Service (Differential - Proof of Service+(x)Days)}* a single field, or are you trying to reference multiple fields here?

If you're trying to reference multiple fields here, then that would cause an error.

Again, any additional information that we could use to troubleshoot this for you would be greatly appreciated.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 03:00 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jun 11, 2023 04:25 PM

Thank you, Ben; I got it to work.