function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
LoneStar69LoneStar69 

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.
ManojjenaManojjena
Hi Mariruz,

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 .

 
Mudasir WaniMudasir Wani
Hello Mairuz,

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