function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
reidhireidhi 

Help with a formula

I have a custom object called orders and within it a field called order number.  I need help with a formula that will populate the word "pending" when the field is blank, but not change the existing value if there is one.

 

Can anyone help me with this?

James_RussoJames_Russo
Sounds like you could use a workflow rule.  Every time the order is created or edited and the Order Number = Blank than do a field update to make the field say "Pending"
reidhireidhi

Yes, however, I cannot get the forumla to leave the value as is if there is something populated there already.
hhuiehhuie
If shouldn't be overriding the value if you set the Workflow Rule to only trigger if there is no value in that field