Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 04, 2023 07:05 PM
Hi! I'm pretty new and having difficulty figuring out the logic of how to write this:
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..
This seems simple but I can't seem to figure out the correct formatting to return correct results. Help appreciated 😄
Solved! Go to Solution.
Nov 05, 2023 05:41 AM
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!
Nov 05, 2023 05:41 AM
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!
Nov 06, 2023 12:26 PM
Thank you so much for the help @Arthur_Tutt That worked beautifully 🙂