Sample Formula: IF( AND( NOT(ISBLANK(Email)), CONTAINS(Email, '@') ), LPAD(RIGHT(Email, LEN(Email) - FIND('@', Email) + 1), LEN(Email), '*'), '' ) Output: https://youtu.be/wsraxmI1Dmc
There is no split() in Salesforce formula. It is available in Apex if you want to go with Trigger. But, you can use RIGHT, LEN and FIND methods to split ....
1. Create a Multi-Select Picklist field. 2. Create a Formula Field and use the PICKLISTCOUNT(). PICKLISTCOUNT() will return the number of selected options from a Multi-Select Picklist field. Output:
OR operator and INCLUDES method can be used to create Formula field based on Multiselect Picklist to check against multiple values in Salesforce.Sample Formula Field:Output:
Sample Formula for Easter Standard Timezone(GMT or UTC - 4): IF( HOUR(TIMEVALUE( CreatedDate - 4/24 ) ) < 12, "Morning", IF( HOUR(TIMEVALUE( CreatedDate - 4/24 )) < 16, "Afternoon", "Evening" ....
In the Formula Field, INCLUDES() can be used to check whether the Multi Picklist Field has a specific value. Sample Formula Field: Output:
Sample formula:AND (Date__c <=TODAY(),Date__c >= ( TODAY() - 15 )) Output:
Sample Formula:IF(CONTAINS( TEXT( End_Date_Time__c - Start_Date_Time__c ), '.' ),IF(DATEVALUE( End_Date_Time__c ) = DATEVALUE( Start_Date_Time__c ),'0',MID( TEXT( End_Date_Time__c - Start_Date_Time__c ), 0, FIND( '.', TEXT( End_Date_Time__c - Start_Date_Time__c ) ) - ....
1. Use target as "_self". 2. Use "/lightning/r/" as the path.
Sample Formula: IF(YEAR( End_Date__c ) = YEAR( Start_Date__c ) && MONTH( End_Date__c ) = MONTH( Start_Date__c ),0,IF ( YEAR( End_Date__c ) = YEAR( Start_Date__c ),MONTH( End_Date__c ) - MONTH( Start_Date__c ) ....