current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 3 down vote favorite

I want to copy data from one field in another if checkbox is true, I know I can do it by trigger but I want to do it in formula field, I don't know how to check the checkbox field my code is like this

IF (
    AND(
        ISPICKVAL( Lease_Lease_Assign_Applicable__c, "Yes" ),
        Lease_Assignment_Received__c
    ),
    "Yes",
    "NA"
)
share|improve this question

1 Answer 1

up vote 5 down vote

if I understood ur requirement correctly, you want to pass the value of the picklist field Lease_Lease_Assign_Applicable__c into a formula text field if the checkbox is checked... the below formula should do it..

IF(
  Lease_Assignment_Received__c,
  TEXT(Lease_Lease_Assign_Applicable__c),
  'NA'
)
share|improve this answer
1  
Welcome to SFSE @Vasmi. Good to see you over here, seen you for a long time on the answers community. Welcome :) –  sfdc_ninja Aug 8 at 13:49
    
Thanks @sfdc_ninja .. u guys r doing an awesome job here :-) –  Vamsi Krishna Aug 8 at 18:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.