Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

# Tag Info

Accepted

### Did something happen with the Month function?

Nothing's changed that I'm aware of. But at any rate, the error spells it out for you. MONTH() requires a Date, and you've given it CreatedDate which despite the name is a Datetime. You're trying to ...

### IF Formula help - Multiple Parameters Issue

You can use IF(ISBLANK(Current_Customer_ID__c),IF(ISBLANK(BT_Account_Number__c), New_License_Manager_ID__c, BT_Account_Number__c), Current_Customer_ID__c) or IF(NOT(ISBLANK(Current_Customer_ID__c)),...
Accepted

### Formula field date subtraction

Simple date subtraction, as Amit suggests in the comments, would be a decent approximation. Datetimes (and their closely related cousin, Dates) can be subtracted to give you a decimal (in the case of ...

### When I would change a formula, then when the value from that formula will change?

Formula fields do not have their values stored, they are calculated on-demand. Every time you query a record in Apex or view a record in a web browser, the formula fields are re-calculated. So there ...
1 vote

### Help creating a filter

Try creating a formula field of type number and decimal place zero. Use below formula IF (IsClosed, Round(ClosedDate - CreatedDate, 0), Round(NOW() - CreatedDate, 0)) Use this formula field as a ...
1 vote
Accepted

### Summary Level Formula - Sum Closed/Won Opportunities

You have to do this in two steps Step 1 - Create a Row Level Formula called Amount Won IF (ISPICKVAL(StageName,'Closed/Won',Amount,0) Step 2 - Create a Summary Level Formula that sums the row level ...
1 vote
Accepted

### How to change boolean result to a compatible currency value in a formula field

A few things to note here: When you are making multiple comparisons against a single field, you should consider using CASE() to save yourself a potentially significant amount of typing A formula ...
1 vote

### How to change boolean result to a compatible currency value in a formula field

Remove the last IsBlank(null) instead, just make it null. By saying IsBlank, you are returning true (as null is always blank) and hence the complain from the compiler.
1 vote

### Formula Help - alternative of using nested if in formula due to size limitation

Often with this sort of situation, the proper course of action is more of a paradigm shift; rather than fixing or improving this formula, it might be more prudent to ask if a Formula Field is the ...
1 vote

### Return the start of a email domain

you can try using this formular: LEFT(Email_Domain__c, FIND(".", Email_Domain__c) - 1) it returns everything before the first dot. Hope it helps.

Only top scored, non community-wiki answers of a minimum length are eligible