function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Gwen ONeill 9Gwen ONeill 9 

ischanged checkbox

I'd like to create a formula that would mark a checkbox as true if a field is changed in 1 of 3 ways

We have a field called AUM and three levels based on the AUM.  I need to create a checkbox when a specific level is met.  For instance, if the AUM went from 600k to 700k, then the checkbox is true.  But I only want the box checked IF the amount changes.  

This is the formula I started with, I know it's incorrect, but would like suggestions....  Thanks!

If (Assets_Under_Management__c  (ISCHANGED) >= 700000, true,false)
Best Answer chosen by Gwen ONeill 9
mukesh guptamukesh gupta
Hi Gwen,

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.


if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh

All Answers

VinayVinay (Salesforce Developers) 
Hi Gwen,

Try below validation.
IF(AND((Assets_Under_Management__c>= 700000),ISCHANGED(Assets_Under_Management__c)), true,false)
Please mark as Best Answer if above information was helpful.

Thanks,
Gwen ONeill 9Gwen ONeill 9
It looked like it would work, but my error is saying ISCHANGED can not be used in this kind of formula.  I hadn't seen that before.
VinayVinay (Salesforce Developers) 
Can you share screenshot of errror that you see?
Gwen ONeill 9Gwen ONeill 9
User-added image
mukesh guptamukesh gupta
Hi Gwen,

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.


if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh
This was selected as the best answer
Gwen ONeill 9Gwen ONeill 9
Thank you - I guess I was too foggy yesterday.  Once I saw your response, it was a "duh!" moment.  Thank you again!!