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.
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.
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:
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:
Thank you... not working. Here's what I wrote in the formula:
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}
)
@Tom_David , I believe this is what you're trying to do:
In this example, the formula for Field 3 is just
@Tom_David , I believe this is what you're trying to do:
In this example, the formula for Field 3 is just
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.