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
Rahul Chavan 36Rahul Chavan 36 

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
 
Best Answer chosen by Rahul Chavan 36
ravi soniravi soni
hy rahul,
try following formula.
For WorkFlow - 1
IF(Number__c < 100,150,0)
For WorkFlow - 2
IF(Number__c >= 100,75,0)
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.
IF(Number__c < 100,150,
IF(Number__c >= 100,75,0)
let me know if above info is useful to you and don't forget to mark it as best answer.
Thank you
 

All Answers

PriyaPriya (Salesforce Developers) 

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

ravi soniravi soni
hy rahul,
try following formula.
For WorkFlow - 1
IF(Number__c < 100,150,0)
For WorkFlow - 2
IF(Number__c >= 100,75,0)
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.
IF(Number__c < 100,150,
IF(Number__c >= 100,75,0)
let me know if above info is useful to you and don't forget to mark it as best answer.
Thank you
 
This was selected as the best answer
Rahul Chavan 36Rahul Chavan 36
thank you priya , for help the field name is lead numbers , this field update on same object.thank you in advance..
Rahul Chavan 36Rahul Chavan 36
thank you priya , for help the field name is lead numbers , this field update on same object.thank you in advance.
ravi soniravi soni
hy rahul,
did you try my solution?
try it and let me know what is your opinion?
Thank you
Rahul Chavan 36Rahul Chavan 36
yes with time flow it work. thank u veer