If And formula to check 2 conditional fields

Question

Hi! I'm pretty new and having difficulty figuring out the logic of how to write this:

(single select) Status = "review 1" or "review 2"
(Long text) Feedback must not be blank

If the above is true then it should provide an output of - "Ready!"

And then preferably the errors can drill down to the exact issue..

If the status is neither of those - Error, wrong status!
If the feedback box is blank - Error, missing feedback!

This seems simple but I can't seem to figure out the correct formatting to return correct results. Help appreciated 😄

Arthur_Tutt · Accepted Answer

Hey @kb1 yeah there's a few nested IF statements here that can make the logic and syntax a bit messy. I drafted something up that should work for you (will need to update my variable names to match your field names).

Sample table setup and desired output:

Formula:

IF(
  NOT({Feedback}),
  "Error, missing feedback!",
  IF(
    NOT(
      OR(
        {Status} = "Review 1", {Status} = "Review 2"
      )
    ),
    "Error, wrong status!",
    IF(
      AND(
        OR(
          {Status} = "Review 1", {Status} = "Review 2"
        ), {Feedback}
      ), 
      "Ready!"
    )
  )
)

Let me know if this works for you!

kb1 · Answer

Thank you so much for the help @Arthur_Tutt That worked beautifully &#128578;

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded