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!
Best answer by Jeremy_Oglesby
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)
)
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)
)
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!
+1Since 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)
)
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.