You need to sign in to do that
Don't have an account?
LoneStar69
Is it possible to show alphanumerics in same salesforce formula?
Hi,
Wondering is it possible to show alphanumerics in the formula output?
IF( Hours__c < 10, Hours__c *6, Hours__c / 8)
Assuming Hours__c is 8.
So some thing like,
if true, 48 Mins
if not, 1 Day
Are there any other functions i can make use of?
Thanks.
Wondering is it possible to show alphanumerics in the formula output?
IF( Hours__c < 10, Hours__c *6, Hours__c / 8)
Assuming Hours__c is 8.
So some thing like,
if true, 48 Mins
if not, 1 Day
Are there any other functions i can make use of?
Thanks.
I don't think it is possible with the help of formula . You can achieve with the help of trigger and update in a text field .
You can definitely do that,
Select the return type as text and use advance formulae to achieve this.
Here are some useful formulaes have a look
https://help.salesforce.com/apex/HTViewHelpDoc?id=useful_advanced_formulas.htm&language=en (https://help.salesforce.com/apex/HTViewHelpDoc?id=useful_advanced_formulas.htm&language=en)
https://help.salesforce.com/help/pdfs/en/salesforce_useful_formula_fields.pdf
Donot forget to select best answer to make our efforts visible in the developer forum.
Please mark this as solution by selecting it as best answer if this solves your problem, So that if anyone has this issue this post can help