You need to sign in to do that
Don't have an account?
Rahul Chavan 36
i create 2 workflow rule with field update on same object, evaluation criteria is create and everytime edited. i want to do---
workflow rule 1... if number field is less than 100-- update field to 150
workflow rule 2..if number field is grater or equal to 100--update field to 75
i created workflow with formula but my formula is wrong i did not get desired result. plz help me in step by step solution in detail which formula to use.
and plz do not refer trailhead or any link , as beginner i refer it but stuck in formula , so plz help which formula resolve it. thank you in advance
workflow rule formula issue
i create 2 workflow rule with field update on same object, evaluation criteria is create and everytime edited. i want to do---
workflow rule 1... if number field is less than 100-- update field to 150
workflow rule 2..if number field is grater or equal to 100--update field to 75
i created workflow with formula but my formula is wrong i did not get desired result. plz help me in step by step solution in detail which formula to use.
and plz do not refer trailhead or any link , as beginner i refer it but stuck in formula , so plz help which formula resolve it. thank you in advance
try following formula.
For WorkFlow - 1 For WorkFlow - 2 but my concern is that if you have a field on object and you want to update it on edit or create then simply you can use formula like below. you don't use workflow.
if you have another requirment then maybe you are right. let me know if above info is useful to you and don't forget to mark it as best answer.
Thank you
All Answers
Hi Rahul,
Please provide the field name for Number Field and the field you want to update. I will give you the solution.
Regards,
Priya Ranjan
try following formula.
For WorkFlow - 1 For WorkFlow - 2 but my concern is that if you have a field on object and you want to update it on edit or create then simply you can use formula like below. you don't use workflow.
if you have another requirment then maybe you are right. let me know if above info is useful to you and don't forget to mark it as best answer.
Thank you
did you try my solution?
try it and let me know what is your opinion?
Thank you