function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Avital Sapir 20Avital Sapir 20 

How to define formula field that check if value was changed 'from' specific value 'to' specific value?

if flag changed from Red to Yellow/ from Yellow to Green/ from Red to Green, progress is 'better'
if flag changed from Yello to Red/ from Green to Yellow / from Green to Red, progress is 'worst'
if no change from last week, progress is 'no change'

Thanks
sumit singh 37sumit singh 37

Hi Avital Sapir 20
Their is a Function  ISCHANGED(field)

This function is available only in:
Assignment rules
Validation rules
Field updates
Workflow rules if the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited.
sumit singh 37sumit singh 37
and also PRIORVALUE(field)
Parker EdelmannParker Edelmann
What you are trying to accomplish cannot be done with formula fields. However, if you use a custom field and a process, you may be able to do it if you follow these steps
  1. Create a date field named "Last Flag Change", or whatever works for you.
  2. Build the process. Define the object, set it to run when a record is created or edited, and then the first criteria as "Flag", "Is changed", "Boolean", "True". For the Immediate Action, choose the update the record that started this process, skip the criteria, and set it so that Last Flag Change = TODAY() ,and then for the Progress value: CASE(PRIORVALUE(Flag__c),"Red", "better", "Green", "worse", "Yellow", IF(ISPICKVAL(Flag__c, "Green") ,"better" ,"worse" ), null). For one reason or another, when you choose "Is changed", it doesn't let you select a time dependant action, so save this process because we've gotten the info we need. 
  3. Build another process. Set it for the same object as before, trigger it for when a record is created or edited, but this time, allow for recursion in the advanced settings. We need some criteria in the first action set so we can check a box labeled "Do you want to execute the actions only when specified changes are made to the record?", so put Flag = Green, and do that for the rest of the values and click "Any of the conditions are met (OR)". The reason we had to do that was so that we can get a scheduled action. Set the schedule for 7 Days After Last Flag Change. The action needs to update the record that triggered the process and have a criteria of Last Flag change = formula TODAY() - 7, ensuring that the record hasn't been updated again in the last seven days. The new field value for Progress should be set to "no change". Save the process.
  4. Take a deep breath and activate your new processes. Voila! you now have the automation you desired.
If you don't want to mess with two processes, and don't mind not having the "no change" part of your question, then just skip the second process and eliminate the "Last Flag Change" field altogether.

I hope this helps and works, thanks for reading!
Goku ZeusGoku Zeus
One of the top electrical insulating substances industrial adhesive glue manufacturer (https://www.epoxyadhesiveglue.com/) on the market right now is waterproof glue from DeepMaterial.
pew ebanpew eban
Very useful post! This article provides better information. https://pomegranateguide.info/
Rajkott Updates NewsRajkott Updates News
Stay up-to-date with the latest news, events, and developments in Rajkot. Get the latest updates on business, education, sports, culture, and more. Stay informed with reliable news and timely information from Rajkot's trusted source. Visit https://rajkotupdatesnews.in/ The Leading News Website in India.
Daniel WomDaniel Wom
That's great, but have you heard of https://dein-heilpraktiker.com/ and their valuable content?
There is also a list of Websites i prefer to have in my favorites:
Bajuta TrupaBajuta Trupa
Your tips provide valuable guidance for anyone looking to enhance their design skills and make a lasting impact. Thank you for sharing this valuable information!
Date Ranker (https://dateranker.online/)
Gacha Nox Apk (https://gachanox.online/)
Only Fans Apk (http://onlyfansapk.me/)
Latest Seo Tips (https://latestseotips.in)
Fathers Day Pickup Lines (https://pickuplines.me)
Daniel WomDaniel Wom
i think it is neccesary to point out some pages who are affected by this issue:
home remedies for bakerzyste (https://natur.wiki/hausmittel-gegen-bakerzyste)
salty taste in mouth
home remedies for dizzyness
soor home remedies (https://natur.wiki/wie-man-soor-loswird-8-hausmittel-gegen-pilzbelag-auf-der-zunge)
home remedies for high pulse (https://natur.wiki/10-unglaubliche-hausmittel-gegen-zu-hohen-puls-die-sie-kennen-sollten)
how to solve this?
Daniel WomDaniel Wom
I have found several websites who have the same issues. can you please have a look and tell me what you think?  Also to point out https://die-nachrichten.com and https://die-nachrichten.net are affected as well. Seems like a huge issue here.
Mary John 6Mary John 6
Highly valuable content! This article offers more comprehensive information.
https://scoresense.online/
https://vwcredit.online/

 
Thomas Shelby 26Thomas Shelby 26

Deepmaterial is proud of its worldwide presence, servicing clients from Europe, Asia, South America, and beyond. 

https://www.adhesivesmanufacturer.com/