Feb 20, 2020 09:59 AM
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!
Solved! Go to Solution.
Feb 20, 2020 10:38 AM
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)
)
Feb 20, 2020 10:38 AM
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)
)
Feb 20, 2020 10:55 AM
Perfect that works great, thank you!
Apr 21, 2023 03:13 PM
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.