You need to sign in to do that

Don't have an account?

ArmanM

# Custom field formula

Hi,

I would like to create a custom field formula that has two conditions and based on that conditions it will perform a formula.

*IF (field is empty/null) -> perform formula 1

otherwise (field is not empty/null) -> perform formula 2

Thanks !

I would like to create a custom field formula that has two conditions and based on that conditions it will perform a formula.

*IF (field is empty/null) -> perform formula 1

otherwise (field is not empty/null) -> perform formula 2

Thanks !

RaidanIn that case you can use a Workflow (Field Update) or Process Builder. ## All Answers

RaidanWhen you say perform a formula, are you referring to returning the value from a formula? To do so, make sure you have two formula fields that return the same data type. Say you have Text_Formula_1__c and Text_Formula_2__c (both returns text). Create a new formula field (same return data type), let's call it Text_Formula_3__c (return text). And the formula will look like this:

ArmanMOkay let me try explaining myself a little more. Lets say I already have a currency field called Currency_c and a number field Numbers_c. I want to create a new custom formula field Rate_c which would perform (Currency_c *10) / Numbers_c if Rate_c is left emplt/blank. How would this be possible ? RaidanI am a bit confused about leaving the Rate__c field blank. Rate__c is a formula field, so it is read-only. However to check for blank/null, you can use ISBLANK() function. ArmanMNo. I want to make Rate__c an actual field where the user can put a value in and if the user doesnt put something in then that formula will execute RaidanIn that case you can use a Workflow (Field Update) or Process Builder. ArmanMokay thanks, I'll try that out