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

Hot answers tagged

3 votes
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 ...
user avatar
  • 47k
2 votes

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)),...
user avatar
  • 4,452
2 votes
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 ...
user avatar
  • 47k
2 votes

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 ...
user avatar
  • 47k
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 ...
user avatar
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 ...
user avatar
  • 61.5k
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 ...
user avatar
  • 47k
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.
user avatar
  • 1,550
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 ...
user avatar
  • 142k
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.
user avatar
  • 96

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