+ Start a Discussion
Kiersti FelskaKiersti Felska 

formula values to set another field

trying to write a formula to read values from 4 other fields and if they are set to Yes, set this fields value to Yes but am not sure on how to formulate this one.. my mind is drawing a complete blank :(
pconpcon
IF(OR(Field1__c == 'Yes', Field2__c == 'Yes', Field3__c == 'Yes', Field4__c == 'Yes'), 'Yes', 'No')

This formula will print 'Yes' if any of the fields are 'Yes'
SteveMoSteveMo
What is the datatype od the 4 fields you're evatuating? 
Do all 4 have to be set to Yes or just any one of the 4?
Jeet PadhyaJeet Padhya
Also, what is the datatype of the field whose waluye ure trying to set?