Skip to main content
Solved

Nested IF statement on 3 Checkbox Fields

  • November 4, 2020
  • 3 replies
  • 35 views
A
Forum|alt.badge.img+7

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???

Best answer by Chris_Guthrie

@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})

3 replies

C
Forum|alt.badge.img+12
  • Chris_Guthrie
  • Inspiring
  • Answer
  • November 4, 2020

@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})
A
A
Forum|alt.badge.img+7
  • Admin_Expert
  • Author
  • Participating Frequently
  • November 4, 2020

@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!

C
C
Forum|alt.badge.img+12

PERFECT!!! Thank you!


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

Terms & ConditionsAccessibility statement