The Shrine of Deepak Anand

You're invited to an important session about Salesforce security blind spots with myself and guest Andy Ognenoff from Accenture:   

Andy and I will help you uncover the blind spots many teams overlook and our recommendations on how to find them. Register to save your seat and get the recording afterwards:

https://us06web.zoom.us/webinar/register/2216536750901/WN_wx1EAUvCRp2OGAcwLUpF4w

Hello everyone,  

Following some doc to create the formula for push counter to calculate how many times a sales rep changes the Closed date on an opportunity to a date farther out, formula as below: 

 IF( CloseDate > PRIORVALUE( CloseDate ), IF (MONTH(CloseDate) <> MONTH(PRIORVALUE( CloseDate )) , TRUE, FALSE), FALSE) 

Does anyone know if any formula to count the push when opportunity is on "Negotiation" stage for example please? (as I do not want to track close date changes when opportunity is on early stages). TIA

#Formulas

I need help with a validation rule. There is a custom field on a custom object called "Status" -- There is a status that is "In Progress" -- however that status can only be selected if the value of a different custom field "Subscription Product Status"  is either 1 of  2 different values. (Fulfillment or Live) I wrote this validation rule:  

OR(
AND (
    ISPICKVAL(Status__c,'Ad Fulfillment - Ad In Progress'),
    Subscription_Product_Status__c != 'Fulfillment'
       ),
AND (
     ISPICKVAL(Status__c,'Ad Fulfillment - Ad In Progress'),
        Subscription_Product_Status__c != 'Live'
        )
   )

Here is the problem though. If the value is "Live" then the first AND criteria blocks the record from being saved and if it's Fulfillment the second on blocks it. I've tried a bunch of different ways to solve this and I can't figure it out... this can't be that hard. 

Hi Deepak,

Any idea how we can fire custom action button URL in trigger?

Thanks

I posted this question regarding reports on the answers community but got no responses. Seeing if anyone else can help, seems to be such a simple requirement. Just looking for a 2nd set of eyes on this. 

https://success.salesforce.com/answers?id=9063A000000pj1rQAA

@Reports & Dashboards @Who owes me a beer?!? @The Shrine of Deepak Anand @User Group, Twin Cities, US @User Group, New York City, US @Admin Group, Philadelphia, US @* Salesforce Administrators *  

Hi Deepak, this is Varun here. You were just providing me a solution for spaces in my formula field. I copy pasted exactly what you provided but it still doesn't add the space.

can any one help me on this  priority i need to do it asap.

I have created a Case for a Merchant and in that case View page I want see all the other cases belongs to the current case merchant

Hi @Deepak K Anand 

I came across an answer you've provided in 2013 about auto-hiding/collapsing the chatter feed on every page using a home page custom component (Classic interface). 

https://success.salesforce.com/answers?id=90630000000hPNxAAM

Since you wrote that post, Salesforce have retired the ability to add html components. Can you still use the method, but on a visualforce page, to achieve the same outcome?

Thanks

I Just have to send another round of thanks to @Deepak K Anand 

These wicked cool buttons he helped me create are just the "Bees Knees"

Your help and quick responses are always highly appreciated..

Happy Friday!

IF( 

DATE(YEAR(TODAY()), MONTH(Birthdate), DAY(Birthdate)) = TODAY(), 

"Happy Birthday! " + @Deepak K Anand  , 

"Have a great day anyway, you deserve it!") 

@Salesforce MVP Collaboration Space