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 C...
Forum Discussion
Can you explain a bit about what you are trying to accomplish?
Are those representing two different formula fields?
------------------------------
Mike Tamoush
------------------------------
Are those representing two different formula fields?
------------------------------
Mike Tamoush
------------------------------
…I want it to occur in one field only. Thx
------------------------------
Lynne8817 Lynne8817
------------------------------
------------------------------
Lynne8817 Lynne8817
------------------------------
- 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
------------------------------- 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
------------------------------- 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
------------------------------