How to make a value be automatically entered depending on if another field is blank or not

Hey there.

I am wanting to make a field auto-fill depending on whether another field is empty or not.

E.g. If someone enters a voucher number in the ‘voucher number’ field, the field ‘cost’ is automatically $0. If the voucher number field is left blank, the ‘cost’ is $100.

I’ve tried using the IF function and making it blank but it is saying invalid.

Thanks!

Since you are dealing with currency, you could just use a value of 0 instead of BLANK(). It might make intention more clear as well…

IF(
   {Voucher Number},
   0,
   100 (or reference to {Amount} field)
)
1 Like

Perfect that works great, thank you!

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.