• janeisaac
  • NEWBIE
  • 85 Points
  • Member since 2011

  • Chatter
    Feed
  • 3
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 17
    Questions
  • 27
    Replies
I am getting a Syntax error that says there is an extra comma at the end of the second row in the formula below
I need the formula to check if the first two fields are blank and if they are, use the first solution, otherwise use the second.

IF((AND
   (ISBLANK(Date_Decisioned__c ))),(ISBLANK(Returned_to_Sales_for_Credit_Follow_up__c))),
(TODAY() - (DATEVALUE(Submitted_to_Credit__c))),
(DATEVALUE( Returned_to_Sales_for_Credit_Follow_up__c ))-(DATEVALUE(Submitted_to_Credit__c )))

I am trying to automate the Contract End Date for a renewal term.

I have a custom date field with the Renewal Term Start Date and the number of months in the renewal term.

I want a formula to deliver the new Contract End Date and take into consideration the possibilities of Leap Years.

 

I found a formula (below) on the board that calculates the new date when it is a year later. I know I have to convert the number of months into days first but that will depend on the start date. I am lost as to how to tackle this. Can someone take a shot at this for me?

 

 

DATE(
YEAR (AppDate__c) + (FLOOR((TODAY() - AppDate__c) / 365.2425) + 1),
MONTH(AppDate__c),
IF(AND(DAY(AppDate__c) = 29,MONTH(AppDate__c ) = 02) , 28, DAY(AppDate__c)))

I have a VR written to require the user to enter the Contract Term # of Months, once the opportunity in a particular record type reaches a certain stage (stage 6) or higher.

 

However, its not working - any ideas?

Here is the formula as it stands now:

 

AND (
OR (
ISPICKVAL(StageName, "6 - Proposal/MOU Presented"),
ISPICKVAL(StageName, "7 - Verbal Acceptance"),
ISPICKVAL(StageName, "8 - Contract Sent/Negotiations"),
ISPICKVAL(StageName, "9 - Contract Executed"),
ISPICKVAL(StageName, "10 - Contract Validated "),
ISPICKVAL(StageName, "11 - Internal Kickoff Completed"),
ISPICKVAL(StageName, "12 - Customer Kickoff Completed"),
ISPICKVAL(StageName, "13 - Integration Instructions Sent"),
ISPICKVAL(StageName, "14 - Certification Complete"),
ISPICKVAL(StageName, "15 - Approved for Production"),
ISPICKVAL(StageName, "16 - Launched to Production")),
RecordType.Id="01280000000Luw9AAC",
ISBLANK(Contract_Term_Months__c)
)

 

 

Our record types are based on the record owner's Record Type.  I created a new field on the User record called Record Type that I will manually update.  I need to create a workflow that will update the record type of an Account or Opportunity if the Owner changes and the Record type is not the same as the Record type for the User.

I am looking for some help to create a field on the Opportunity page which sums the amount of Child Opportunities. The child opp has a lookup to the Parent. It does not appear to let me use a Roll-up summary formula to do this so I am looking for help on a way to do this.

I can't figure out why I am getting an Extra comma message referring to the comma after (ISPICKVAL(Status__c,"Done Not Reviewed"))))

 

 

(IF(OR
(AND(Question_Group__c = "A",Answer__c = "Yes"),
(AND(Question_Group__c = "C",Answer__c = "No")),
(AND(Question_Group__c = "B",Answer__c <> " "))),
(ISPICKVAL(Status__c,"Done Not Reviewed")))),"https://c.cs2.content.force.com/servlet/servlet.FileDownload?file=015R00000001kLA",
NULL))

This formula works:

IF(AND(Question_Group__c="A", Answer__c="Yes"),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),null)

 

but when I added a third component to the AND portion of the formula, it breaks it

 

IF(AND(Question_Group__c="A", Answer__c="Yes", ISPICKVAL(Status,"Done Not Reviewed"),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),null))

 

I get the following error message: Error: Incorrect parameter for function 'AND()'. Expected Boolean, received Text.

 

So something about that addition of the pickval component is throwing it off. Does anyone have any suggestions?

 

Thanks,

Jane

I am trying to add a formula field on an Activity which will display the content of a custom field from the Contact that the activity is related to.

 

So far, I cannot see a way to access that field from the Contact object using standard formulas.

Any ideas?

I want to make it so that only users with one of three profiles can edit the Account Name if the record type is Customer.

 

I have it working for one profile but when I try to add an OR statement and include the two other profiles, it does not work:

 

Here is what is working now:

AND(
( $RecordType.Name  ="Customer"),
 ISCHANGED( Name ),
 $Profile.Name<>"System Administrator - Integration"
)

 

Here's what I tried:

AND(
( $RecordType.Name  ="Customer"),
 ISCHANGED( Name ),

OR(

$Profile.Name<>"System Administrator - Integration",

$Profile.Name<>"System Administrator - KM",
$Profile.Name<>"System Administrator - KMGP"

))

 

Can someone see what is wrong with the OR part of this formula?

 

Thank you so much!

Jane

I am trying to create a custom link on the Account Object to create a new Child Account and prepopulate some of the fields in the Child object from data in the Parent account.

 

I cannot locate many of the field ID's in the View Source.

I can find the custom fields but it appears that the ID's for the standard fields are giving me problems.

 

Fields like

  • Parent
  • Billing Address

 

Is there a better way to find those field ID's than View Source? Or can someone tell me the secret sauce in View Source?

 

Thanks,

Jane

I am stumped at how to even start this one.

 

I have a formula field on a Custom Object that is a child of Account object. This formula determines whether an Approval is required and returns a Yes or No, based on the formula. This is part of an Approval Process.

 

I want to add the criteria that if the Account field "Credit Limit" has been changed and the new number is greater than the prior value this will require District Sales Manager Approval. We do have history tracking on this field.

 

Here is the current formula (without any reference to the criteria I am trying to add).IT is working as expected but I need to add this new piece to it.

 

IF(    

OR(

         Fixed_Price_Customer_Pricing_Records__c > 0,

         Restricted_Price_Level_Customer_Pricing__c > 0,

         ISPICKVAL(Account_Type__c,"04 (net 60 day)"),

         ISPICKVAL(Account_Type__c,"06 (net 80 day)"),

         ISPICKVAL(Account_Type__c,"13 (365 day EQ/Sundry)"),

         ISPICKVAL(Account_Type__c,"Fixed Pricing"),

        Current_Sub_Type__c = "67 Dealers"),

     "Yes",

     "No" )

I am trying to create a formula that has three possible results:

a Yellow light,

a Red Light,

or a Green Light.

 

I currently have 2 different fields - each with their own formula. One has the YELLOW light formula, which is the first 6 lines of this below and the other fields uses the Red Light Formula, which is the last 8 lines of the formula. On their own, updating 2 different fields, each of these formulas work as expected. But I need them to work on ONE field.

 

Of course I had to try it, but I really expected that simply combining the two formulas was too easy an option to work right off the bat, so here I am, asking for the help of my Formula Wizards. I am getting the Error on the Function OR in the first line, saying it expected Boolean, received Text.

 

Can someone help me fix this?

 

Jane

 

 

OR(
IF(
     Test_Terms_Update__c =TRUE,
    IMAGE("https://c.cs7.content.force.com/servlet/servlet.FileDownload?file=015M000000057ze","Yellow"),
    IMAGE("/img/samples/flag_green.gif","Green")
),
IF(
OR(
Credit_Hold__c,
Permanent_Hold__c
),
IMAGE("/servlet/servlet.FileDownload?file=015C00000010ljS","Red"),
IMAGE("/img/samples/flag_green.gif","Green")
))