Date Formula - IF Statement Error
I have a date- formula field with the below working if statement: If(IsNull([PO Issue Date]) = false, WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO D...
Forum Discussion
You had an error in the first part of your IF statement. This should give you the output you are looking for.
If(IsNull([Lead Time +Transit Time (Weeks)]),null,
If(IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date], [Lead Time +Transit Time (Weeks)]*7)))
If(IsNull([Lead Time +Transit Time (Weeks)]),null,
If(IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date], [Lead Time +Transit Time (Weeks)]*7)))
Having multiple if statements in there makes it confusing. You only need one. QuickBase will take the first one that is true and discard the rest. So you have to build the formula with that in mind sometimes. If you ever have a scenario where 2 things could calculate as true, you might not get the desired result.
I can try and illustrate that with an example.
If(
[My Text] = "bleh", "not interested",
[My Other Text] = "no way", "hung up on me!",
[My Last Text] = "totally", "ready to buy",
"no status"
)
Does that help at all? You do not need the extra IF, or should not in most cases. Do that and double check line by line that it is doing what you expect it to.
Also the formula posted above seems to have an extra parenthesis at the end if I'm not mistaken. Remove that.
I can try and illustrate that with an example.
If(
[My Text] = "bleh", "not interested",
[My Other Text] = "no way", "hung up on me!",
[My Last Text] = "totally", "ready to buy",
"no status"
)
Does that help at all? You do not need the extra IF, or should not in most cases. Do that and double check line by line that it is doing what you expect it to.
Also the formula posted above seems to have an extra parenthesis at the end if I'm not mistaken. Remove that.