+ Start a Discussion

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?

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"

Yes, however, I cannot get the forumla to leave the value as is if there is something populated there already.

If shouldn't be overriding the value if you set the Workflow Rule to only trigger if there is no value in that field