I want a check box formula to be checked if the following is correct:
1- last modified by a certain user
2- another numeric field is > than a certain value
thank you for your help, really appreciate it.
I have applied what you have suggested and the formula is working however the problem I'm facing is that the formula (checkbox field) is working only after I saved the record. I wanted the checkbox to be checked or not during the user is completing the records and before saving it so the user is aware that the record is above their financial limit.
the idea im trying to reach is if the amount in a field is above the user's financial limit then they need to be warned. (different users have different financial limit)
I changed the (last modified by) to the (case owner but still not working before saving.
any ideas? thanks is advance.