Help

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

Solved
Jump to Solution
1906 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Anesha_Ralston
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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)
)

See Solution in Thread

3 Replies 3
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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)
)

Perfect that works great, thank you!

Hi Jeremy!  Since you gave her the answer, maybe you have an answer for me! 

How can I do it where I can say, if the date is in January, I want to put the word "January" in another field, if date is Feb, then "February", etc.  Basically, I am trying to break out the month from the date field and put it into another field.