Ahhh ok. This can be done with nested Ifs, or something like this:

If(

[Start - Hang]<Date(2021,7,26) and [Paint Garage]=true, [BOARD COUNT]*[DW PT/UP (1) SLP],

[Start - Hang]<Date(2021,7,26) and [Paint Garage]=false, [BD CT PT/UP]*[DW PT/UP (1) SLP],

[Start - Hang]>Date(2021,7,26) and [Paint Garage]=true, ([BOARD COUNT]*[DW PT/UP (1) SLP])+([BOARD COUNT]*[DW PT/UP (2) SLP]),

[Start - Hang]>Date(2021,7,26) and [Paint Garage]=false, ([BD CT PT/UP]*[DW PT/UP (1) SLP])+([BD CT PT/UP]*[DW PT/UP (2) SLP])

)

------------------------------

Michael Tamoush

------------------------------

Original Message:

Sent: 08-17-2021 11:59

From: BuildPro

Subject: Need assistance with formula please

It can be either one of those...depending on whether [Paint Garage] checkbox is true or not.

This is the original formula that worked.

If

([Paint Garage]=true,

[BOARD COUNT]*[DW PT/UP (1) SLP],

[BD CT PT/UP]*[DW PT/UP (1) SLP])

I just need to change it if the start-hang is after 7/26/21 to reflect the addition of [BOARD COUNT]*[DW PT/UP (2) SLP] or ([BD CT PT/UP]*[DW PT/UP (2) SLP]

------------------------------

BuildPro

Original Message:

Sent: 08-17-2021 11:38

From: Michael Tamoush

Subject: Need assistance with formula please

Sorry, I didn't notice one was a greater than and one was a less than sign. I thought both conditions were identical.

As Michael Karr said, there is a confusion somewhere with what result you are trying to produce. If we isolate the first part of the formula (as Michael did) and the 'Start-Hang is Less Than the desired date', which number do you want to have shown in this field?

[BOARD COUNT]*[DW PT/UP (1) SLP]

or

[BD CT PT/UP]*[DW PT/UP (1) SLP]

------------------------------

Michael Tamoush

Original Message:

Sent: 08-17-2021 10:45

From: BuildPro

Subject: Need assistance with formula please

…I want it to occur in one field only. Thx

------------------------------

Lynne8817 Lynne8817

Original Message:

Sent: 08-16-2021 18:40

From: Mike Tamoush

Subject: Need assistance with formula please

Can you explain a bit about what you are trying to accomplish?

Are those representing two different formula fields?

------------------------------

Mike Tamoush

Original Message:

Sent: 08-16-2021 16:56

From: Lynne8817 Lynne8817

Subject: Need assistance with formula please

I know there are several thing wrong with this, but I wanted to make sure you knew what I was trying to accomplish. thank you

If

([Start - Hang]<Date(2021,7,26) and [Paint Garage]=true,

[BOARD COUNT]*[DW PT/UP (1) SLP],

[BD CT PT/UP]*[DW PT/UP (1) SLP],

If

([Start - Hang]>Date(2021,7,26) and [Paint Garage]=true,

([BOARD COUNT]*[DW PT/UP (1) SLP])+([BOARD COUNT]*[DW PT/UP (2) SLP]),

([BD CT PT/UP]*[DW PT/UP (1) SLP])+([BD CT PT/UP]*[DW PT/UP (2) SLP]))

------------------------------

Lynne8817 Lynne8817

------------------------------