Field 1: is a currency field
Field 2: a checkbox
Field 3: is a currency field
I need a Formula in field 3 to do this: IF field 2 = 1, copy & paste the value in field 1 to field 3.
Thank you.
Solved
Help with Formula Syntax Please (Newbie)
+10Best answer by Ron_Daniel
@Tom_David , I believe this is what you're trying to do:
In this example, the formula for Field 3 is just
IF({Field 2}=1, {Field 1})
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
+22
IF(
AND({Field 1}, {Field 2}),
IF(
{Field 1} = {Field 2},
{Field 1}
)
)
There's a bit of nuance I want to call out to you.
A formula won't copy and paste a value. It will simply compute and display (return) the value that it computes.
Field 3 will return a currency formatted number, but it is a formula field.
Additionally, you'll want to be sure that in the field settings for your formula field are set to display the result in a currency format.
If you don't complete this step, then you will simply be returned a number.
Take this snippet for example:
IF(
AND(5.24, 5.24),
IF(
5.24 = 5.24,
5.24
)
)If you were to feed the formula field this snippet without specifying the formatting, it would return you with the default formatting of an integer, thus leaving you with just 5.
Refer to the screenshot below for steps on properly setting the formatting:
+10
IF(
AND({Field 1}, {Field 2}),
IF(
{Field 1} = {Field 2},
{Field 1}
)
)
There's a bit of nuance I want to call out to you.
A formula won't copy and paste a value. It will simply compute and display (return) the value that it computes.
Field 3 will return a currency formatted number, but it is a formula field.
Additionally, you'll want to be sure that in the field settings for your formula field are set to display the result in a currency format.
If you don't complete this step, then you will simply be returned a number.
Take this snippet for example:
IF(
AND(5.24, 5.24),
IF(
5.24 = 5.24,
5.24
)
)If you were to feed the formula field this snippet without specifying the formatting, it would return you with the default formatting of an integer, thus leaving you with just 5.
Refer to the screenshot below for steps on properly setting the formatting:
Thank you... not working. Here's what I wrote in the formula:
IF(AND({Cleaning Fee}, {2021 Cleaned}), IF({Cleaning Fee} = {2021 Cleaned}, {Cleaning Fee}))
Do you see my error?
Field 1=Cleaning Fee (Currency)
Field 2=2021 Cleaned (Checkbox)
Field 3=Cleaning Charge (Formula, formatted to Currency)
+22Thank you... not working. Here's what I wrote in the formula:
IF(AND({Cleaning Fee}, {2021 Cleaned}), IF({Cleaning Fee} = {2021 Cleaned}, {Cleaning Fee}))
Do you see my error?
Field 1=Cleaning Fee (Currency)
Field 2=2021 Cleaned (Checkbox)
Field 3=Cleaning Charge (Formula, formatted to Currency)
Curious.
Any additional details about your fields we might be overlooking? I wasn't able to replicate any issues when tested:
I also realized that part of my formula was redundant, but they're functionally the same.
IF(
AND(
{Cleaning Fee},
{2021 Cleaned}
),
{Cleaning Fee}
)
+21@Tom_David , I believe this is what you're trying to do:
In this example, the formula for Field 3 is just
IF({Field 2}=1, {Field 1})
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
+10@Tom_David , I believe this is what you're trying to do:
In this example, the formula for Field 3 is just
IF({Field 2}=1, {Field 1})
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
Yes, that worked... and it looked a lot more like a spreadsheet formula (which is where I have spend most of my time). Thanks.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.