Forum Discussion
MichaelTamoush
4 years agoQrew Captain
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
------------------------------
BuildPro
4 years agoQrew Captain
Basically, if the Start - hang date is before 7/26/2021, I want one set the formula (without the + stuff to happen)…
if the start-hang date is after 7/26/2021, I want the formula with the + stuff to happen…
------------------------------
Lynne8817 Lynne8817
------------------------------
if the start-hang date is after 7/26/2021, I want the formula with the + stuff to happen…
------------------------------
Lynne8817 Lynne8817
------------------------------
- AustinK4 years agoQrew CommanderThe problem is your formula appears to not be functional at all even if it was set up in that way. For example the top if statement would not actually do anything.
1. ([Start - Hang]<Date(2021,7,26) and [Paint Garage]=true,
2. [BOARD COUNT]*[DW PT/UP (1) SLP],
3. [BD CT PT/UP]*[DW PT/UP (1) SLP],
If we break it down by line..
1. If the start date is before 7/26/21 and paint garage is true, this works. Then it continues to the next line as the criteria has been matched based on the date and checkbox.
2. Here it multiplies board count by some other field, but this is where it begins to break. Assuming this was a text or numeric field it would show whatever calculation was there. However you have a comma at the end and another line with no way for the formula to arrive there.
3. Then we get to this line of the formula which is impossible to reach without the right condition above it.
Can you describe exactly what this is trying to do? You have more issues than just trying to get the dates to work here. In my example above how would you want line 2 and 3 to behave? What data are you wanting to end up with?- BuildPro4 years agoQrew CaptainWorking with one field only - [PR PTUP BUDGET]
In words,
If the [Start-Hang date] is ON/BEFORE 7/26/21 and [Paint Garage] is true, I want ([Board Count]*[DW PT/UP (1) SLP]) to return that number to this field [PR PTUP BUDGET].
If [Paint Garage] is false, I want ([BD CT PT/UP*[DW PT/UP (1) SLP]) to return that number to this same field [PR PTUP BUDGET]
IfIf the [Start-Hang date] is AFTER 7/26/21 and [Paint Garage] is , I want ([BOARD COUNT]*[DW PT/UP (1) SLP])+([BOARD COUNT]*[DW PT/UP (2) SLP]) to return that number to this field [PR PTUP BUDGET].
If [Paint Garage] is false, I want ([BD CT PT/UP]*[DW PT/UP (1) SLP])+([BD CT PT/UP]*[DW PT/UP (2) SLP]) to return that number to this same field [PR PTUP BUDGET]
------------------------------
BuildPro
------------------------------