Here is my formula:
IF(nihrm__IsCommissionable__c = True, "Rates are commissionable to nihrm__Agency__c, at nihrm__CommissionPercentage__c of room revenue generated from package rate. Commission will be paid after the Master Account is settled in full.", "Above rates are non-commissionable.")
The fields I bolded are fields that exist in the same Object. But when my formula runs in the custom field I built for it, it doesn't merge in the value of that field, it just shows the actual name of the field (which is what I bolded)
13 réponses
You are wrapping the date in the double quotes, any field reference should be outside of double quotes else salesforce treats it as literal value. please try the below
IF(ISPICKVAL(nihrm__HousingMethodName__c , "Rooming List"),
"Rooming List: Reservations made by Rooming List must be sent by" + TEXT(nihrm__CutoffDate__c) + ". A Master Rooming List template will be sent from 1440 following confirmation of contract. Rooming List template will include guest name paired with share-withs, if applicable."
you will have to modify the rest of the formula as above
