Using Calculated field in Workflow to set value when empty

đź’¬ General Discussion
1

Hi There,

We have recently added some currency fields, which don’t support Mass Update. Rather than forcing our users to have to set all of these values, I was trying to use a Workflow to set a default value on save.

My goal was to:

  • if the field is empty then set it to 0
  • if the field is not empty then do nothing

I tried using a formula of “{ifThenElse({empty(P0)}; 0.0; {P0})}” where P0 is the field, but this produces results that I can’t quite understand.

Any help appreciated.

1 Like
2

Hi @Golaf

You can use a Workflow Rule with a Field Update action to set the default value for the currency field on save. The Field Update action should use the formula:

IF(ISBLANK(P0), 0.0, P0)

Where P0 is the currency field. This formula will evaluate to 0.0 if the field is empty and will leave the value as-is if the field is not empty.

3

It seems like you are trying to use a formula to set a default value for a currency field in a Workflow, but the formula is not producing the expected results.

You could try a different formula, such as:

IF(ISNULL({P0}), 0, {P0})

This formula checks if the field P0 is null and if it is, sets the value to 0, otherwise it does nothing and the field retains its existing value.

I hope this helps! Let me know if you have any further questions.