@joekutta wrote:
I'm encountering a similar issue. I've been attempting to create a condition via formula in Airtable to manage quoting clients based on their status. Here's the formula I've been working with:
IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote", "On Hold - Do not Quote"))
The objective is to ensure that clients are only quoted if they are marked as "Good" in the {On Hold} field. We're aiming to have the "On Hold" status propagate through to an extension used for sending quotes to clients. Moreover, you can download capcut mod apk from the given link.
We're using a single text field for the client's name and a single select field for their status (On Hold/Good). Any insights or solutions would be greatly appreciated!
Your formula seems to be on the right track, but there's a small issue in the comparison part. Let's refine it:
```plaintext
IF(
Type = "Client",
IF(
{On Hold} = "On Hold",
"❌ On Hold - Do not Quote",
"✅ Good to Quote"
)
)
```
This formula checks if the record type is "Client". If it is, then it further checks if the "On Hold" field equals "On Hold". If it does, it returns "❌ On Hold - Do not Quote"; otherwise, it returns "✅ Good to Quote".
Make sure to replace "❌" and "✅" with the appropriate symbols that you want to use in your Airtable setup.
Once this condition is set up, the "On Hold" note should propagate correctly through to your extension used for sending quotes to clients.
