I have a formula i am writing to apply a time zone lead records based on their state. I have tried using the standard State field, as well as a State__c field which is a picklist. I get the same result each time:
CASE(State,
"AL", "CST",
"AR", "CST",
"IL", "CST",
"IA", "CST",
"KS", "CST",
"AZ”, "MST",
"CO”, "MST",
"ID”, "MST",
"MT”, "MST",
"NM”, "MST",
"OR”, "MST",
"MN”, "CST",
"LA”, "CST",
"MS”, "CST",
"MO”, "CST",
"NE”, "CST",
"ND”, "CST",
"OK”, "CST",
"SD”, "CST",
"TX”, "CST",
"WI”, "CST",
"UT”, "MST",
"WY”, "MST",
"WA", "PST",
"CT”, "EST",
"DE”, "EST",
"FL”, "EST",
"GA”, "EST",
"IN”, "EST",
"KY”, "EST",
"ME”, "EST",
"MD”, "EST",
"MA”, "EST",
"MI", "EST",
"NH", "EST",
"NJ", "EST",
"NY","EST",
"NC","EST",
"OH","EST",
"PA","EST",
"RI", ”EST",
"SC", "EST",
"TN", "EST",
"VA", "EST",
"VT", "EST",
"WV", "EST", "NA")
I always recieve an error that says i am missing a ")", and it highlights the first "MST".
Please let me know if i am doing something wrong here...
I have a formula i am writing to apply a time zone lead records based on their state. I have tried using the standard State field, as well as a State__c field which is a picklist. I get the same result each time:
CASE(State,
"AL", "CST",
"AR", "CST",
"IL", "CST",
"IA", "CST",
"KS", "CST",
"AZ”, "MST",
"CO”, "MST",
"ID”, "MST",
"MT”, "MST",
"NM”, "MST",
"OR”, "MST",
"MN”, "CST",
"LA”, "CST",
"MS”, "CST",
"MO”, "CST",
"NE”, "CST",
"ND”, "CST",
"OK”, "CST",
"SD”, "CST",
"TX”, "CST",
"WI”, "CST",
"UT”, "MST",
"WY”, "MST",
"WA", "PST",
"CT”, "EST",
"DE”, "EST",
"FL”, "EST",
"GA”, "EST",
"IN”, "EST",
"KY”, "EST",
"ME”, "EST",
"MD”, "EST",
"MA”, "EST",
"MI", "EST",
"NH", "EST",
"NJ", "EST",
"NY","EST",
"NC","EST",
"OH","EST",
"PA","EST",
"RI", ”EST",
"SC", "EST",
"TN", "EST",
"VA", "EST",
"VT", "EST",
"WV", "EST", "NA")
I always recieve an error that says i am missing a ")", and it highlights the first "MST".
Please let me know if i am doing something wrong here...
When creating a Task, our users fill in the standard object "Due Date" (field name is ActivityDate).
Unfortunately, Salesforce doesn't give us access to ActivityDate when creating a custom formula.
I could create a custom field to use instead of the standard field, but then the users lose the functionality of the "Overdue, Today, Tomorrow..." etc drop-down box in the "My Tasks" section on their home page.
I tried to do this creating a Workflow rule, but as with formulas, Salesforce doesn't provide access to the field ActivityDate to perform any type of operation.
Surely someone else has run into this problem and has a solution?
For every deal that is signed there is a commission pool of 2 to 6 people. The commissions are paid out as the money comes in each month. The customer payments from which the commission payments are made may or may not be large enough to completely pay the commission amounts in month. In that case the remainder rolls over to the next month Example:
Dealer Commission Due: 300 Customer Monthly Payment: 200 September Commission payment:200 October Commission payment: 100
And so on.
I have written a bunch of IF(AND and IF(OR formulas to automatically calculate the payments to be made (depending on funds availability, etc).
My problem is that I am bumping up against the 5000 limit for formulas. I need a way to take the value of a formula (let's say the September Commission Amount) and use that in a new formula.
So the assumption would be that I am taking the value of a field, not the formula itself into the next formula, breaking the chain of formulas and 'resetting' the 5000 character limit????
Does this make sense?
How do I do this? I tried using the Mail Merge Value {!fieldname_c} but it did not disconnect me from the formula chain.
I have several of these complex formulas to create. Using SF Professional.
I was hoping that SFDC would add time based rule evaluation to the workflow capabilities. That is, to run workflow rules without requiring the record to be modified first to trigger the rule.
My example is we allow some accounts be have a protected status as long as they have certain activity in a certain time period. I've created the field that shows the days since said qualified activity occured, I have a workflow that will change the protected status based on the value in that qualified activity age field.
However, the rule only runs when someone modifies the account, so accounts can be falsely protected simply by not editing them.
I'm trying to find a way to make this rule run periodically without the modification.
