2
votes
Text to Date conversion
You'd have to translate the month into a number:
DATE(
VALUE(RIGHT(Field__c, 4)), // year
CASE(MID(Field__c, 3, 3),
'JAN',1,'FEB',2,'MAR',3,'APR',4,'MAY',5,'JUN',6,
'JUL',7,'AUG',8,'SEP',...
- 429k
2
votes
Accepted
How to track time spent in each stage of a custom detail object
Sam!
You can try to enable the Track Field History feature in your custom object:
Then, to track the time spent in each status picklist value create two fields, a process/flow to update them whenever ...
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 ...
- 46.6k
2
votes
Hi, I have one question regarding cloning of profile,
There is a way, but it's not very user-friendly to do so.
You must already know that you can't change your license via UI.
But we can change it via VSCode. You have to follow the below steps.
1) Clone ...
- 436
1
vote
I am unable to edit / delete archive product
This behavior is at least partially documented and is subject to an open idea on the IdeaExchange.
The error message tells you exactly what the problem is. You cannot perform the operation you are ...
- 86k
1
vote
Accepted
How to include the Account Team object's fields in a report that includes Account records
You should be able to see the account team object's fields in the report if you have AccountTeams enabled in your org.
From Setup, enter Account Teams in the Quick Find box, and select Account Teams.
...
- 2,436
1
vote
Accepted
How to show more than 4 fields in Salesforce Lightning Related List
Yes it is possible to show more than 4 fields in the related list in lightning. You can show upto 10 fields in the related list by using Enhanced list in the lightning page.
Take your related lists to ...
- 1,126
1
vote
Need to restrict a user from saving a report in Public Reports folder
I spent a whole day in this and here is the only workaround I found and that I will most likely implement. This workaround was found on the IdeaExchange link you provided.
"This is one of the ...
- 11
Only top scored, non community-wiki answers of a minimum length are eligible