Joe Woltering Posted June 18, 2019 Share Posted June 18, 2019 Seems like this should be fairly simple: I have an option set field with 3 values that I'm trying to update This is my formula where S1 and S2 are two source fields and 1, 2 & 3 are the possible target values. IF(S1 = 'Y', "1", IF(ISEMPTY(S2), "3", "2" )) Link to comment Share on other sites More sharing options...
Audrey Buettner Posted July 2, 2019 Share Posted July 2, 2019 Yes, this is possbile, just need to make sure you use double quotes for all the strings (your Y was in singles); IF(S1 = "Y", "1", IF(ISEMPTY(S2), "3", "2" )) 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