TEXT(YEAR(DATEVALUE(CreatedDate))) + LPAD( TEXT( IF( CEILING( ( DATEVALUE(CreatedDate) - DATE( YEAR( DATEVALUE(CreatedDate) ), 01, 01) + 1) / 7) > 52, 52, CEILING( ( DATEVALUE(CreatedDate) - DATE( YEAR( DATEVALUE(CreatedDate) ), 01, 01) + 1) / 7) )), 2, "0")
When I go to debug my flow and I type something in the lookup area, no results show up.
What could I be doing wrong ?
I got a report request today that I'm having trouble scoping out. The report is generally on Accounts object and I have roll up fields for all of the metirics. Except, the client want to add projections at the beginning of the year for each Account, by month. So, the would enter the predictions for April 2020, May 2020, ect... for each metric that I currently have on the Account.
My question is, how should I handle these predictions given the screen shot they gave me of how they want this report to look? My first thought is to make a custom object (master detail) to Accounts called "Predictions." But even if I do that, I'm not sure i can ever get this layout to exactly match what they are looking for.
Someone help me out on this one, please! Is this even possible? See screen shot of what they are looking for.
So, going from the left hand side, it's grouped by Account type, then Account name which I had to scratch out. Each one of those fields below are roll ups on the Account page. Ok that part is easy.
If we move right, they want each one of those fields sorted by year. That's OK too, I can roll up for each year 2018 and 2019. Cool. For lift percentage, that should be easy with a report formula.
Then this is where I'm lost. How can I show these predections for each month next to these other fields? I can't right? They have the columns grouped by the prediction month. It just doesn't make sense.
Any help appreciated! Thanks in advance.
Tips & Tricks: Creating Sales vs. Goal Reports and Dashboards
I am trying to assign profile to a user and I have cloned a read only profile and I have set the permissions for it. But when I try to assign it to the user, there's only one option availabler for me to choose which is "Standard Platofrm user"
Trailhead challenge "Session-Based Permission Sets and Security"
Can someone please help me with this?
Thanks in advance
If a field changes from a specific value to another specific value, I'd like it to trigger.
I need to get smart on Process Builder, but I'm not there yet. What I'm wanting, specifically, is that if an Order's Payment Status was at Invoiced and changes to Paid, it will trigger an email.
AND ( ISCHANGED(Payment__status__c), TEXT( PRIORVALUE( Payment__status__c ) ) = "Invoiced" TEXT(Payment__status__c) = "Paid" )
ISPICKVAL(LocationType, "Work Order")
IsMobile = True
o vea este video https://www.youtube.com/watch?v=gnDSqTkVkY8
Check this article https://help.salesforce.com/articleView?id=000334028&type=1&mode=1
or view this video https://www.youtube.com/watch?v=gnDSqTkVkY8
Is there any way , it can be tracked through report. My marketing team is using Marketo.
What you're looking for is to retrieve past data that you did not record anywhere. That is not possible unless you have backups of that data, or are otherwise able to calcate it using the data that you have. Alternatively, you may have to search for a Flux Capacitor at Radio Shack ;)
What you'll want to do is begin recording this data for the future. One way is by setting up reporting snapshots that can record reports in a custom object.
Verification code has apparently been send to my email (not the .invalid :)), but that was an hour ago and clicking to resend the code didn't help
Any ideas please?