
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 04, 2020 06:42 AM
I need to populate a field with a value based on three conditions:
- Checkbox Field “Current Edits Complete” = 1
or - Checkbox Field “No Changes Suggested” = 1
AND - 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???
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 04, 2020 07:59 AM
@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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 04, 2020 07:59 AM
@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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 04, 2020 08:06 AM
PERFECT!!! Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 04, 2020 08:22 AM
No problem. Feel free to reach out if you need any other help!
