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.

Nested IF statement on 3 Checkbox Fields

Topic Labels: Formulas
Solved
Jump to Solution
1779 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Admin_Expert
6 - Interface Innovator
6 - Interface Innovator

I need to populate a field with a value based on three conditions:

  1. Checkbox Field “Current Edits Complete” = 1
    or
  2. Checkbox Field “No Changes Suggested” = 1
    AND
  3. Checkbox Field “Content Implemented” = 0

So, if Edits are complete or No Changes Suggested are checked - BUT - Contentent Implemented must be empty, I want to bring back the {Editor copy}, otherwise I want the cell blank.

Here is what I have built, but it doesn’t grab the records where No Changes Suggested is selected.

IF({Current Edits Complete}=1,IF({Content Implemented}=1,"",IF(OR({No Changes Suggested}=1,{Current Edits Complete}=1),{Editor copy})))

Thoughts???

1 Solution

Accepted Solutions
Chris_Guthrie
7 - App Architect
7 - App Architect

@Admin_Expert I think this is what you’re looking for here

IF(AND({Content Implemented}=0,OR( {Current Edits Complete}=1, {No Changes Suggested}=1)),{Copy Editor})

See Solution in Thread

3 Replies 3
Chris_Guthrie
7 - App Architect
7 - App Architect

@Admin_Expert I think this is what you’re looking for here

IF(AND({Content Implemented}=0,OR( {Current Edits Complete}=1, {No Changes Suggested}=1)),{Copy Editor})

PERFECT!!! Thank you!

No problem. Feel free to reach out if you need any other help!