Leading Through Change with Data
COVID-19 Data Hub
COVID-19 Global Daily Tracker
Global Economy Data Track
Government Data Track
Healthcare Data Track
Leading Through Change
Leading Through Change Blog
< Back to List
Formula: PRIORVALUE - allow usage in Custom Formula Field
I am trying to create a text field where it will automatically update
it's value based upon the "highest escalation level a case ever
reached".To solve the above, I attempted to create a TEXT Formula based Field,
but I then find out that PRIORVALUE can only be used in Validation Rules. IF(ISPICKVAL(STATUS,"New"),"New",(PRIORVALUE(STATUS))
IF(ISPICKVAL(STATUS,"Escalated to L3"),"L3",(PRIORVALUE(STATUS))
IF(ISPICKVAL(STATUS,"Escalated to Engineering"),"Eng",(PRIORVALUE (STATUS))
)This formula is probably what I needed, but currently SF doesn't support usage of PRIORVALUE to create a custom text field....
- 1 year ago
The Landmark © One Market St.,
San Francisco, CA 94105
If you can't find what you're looking for,
contact Salesforce Customer Support.
Powered by Community Cloud.
Learn More >
Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.
Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.
Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.
Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.