Hi,

Can you please help me what formula will need to use to get field value depending on which field been populated?

I have 2 custom fields:
1. Original Pick
2. Revised Pick

Then, I created formula field "Final_Pick__c". This formula field have a condition of if Original Pick is populated, value should be "Original Pick". Else, value should be Revised Pick.

TYIA!