Joe Woltering Posted March 2, 2021 Share Posted March 2, 2021 I need to write a formula in Scribe Insight Workbench that checks two fields for data with 3 possible outcomes. For some reason, it's just not coming to me. e.g. Field 1 CONTAINS DATA but Field 2 DOES NOT CONTAIN DATA = Outcome #1 Field 1 DOES NOT CONTAIN DATA but Field 2 CONTAINS DATA = Outcome #2 Neither Field 1 NOR Field 2 CONTAIN DATA = Outcome #3 I've tried nested IF statements using ISEMPTY but I am only able to ever produce two outcomes. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now