You need to sign in to do that
Don't have an account?
Gwen 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)
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)
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
Try below validation. Please mark as Best Answer if above information was helpful.
Thanks,
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