Help

Nested IF statement on 3 Checkbox Fields

Topic Labels: Formulas
Solved
Jump to Solution
1533 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!