Part, but not all, of updated formula working
I have a checkbox field containing a formula. We needed to make some changes, and not quite getting the syntax correct. Would appreciate some help/input, please. Here is the original formula - th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendUnlike excel you normally do not need to nest your IFs so this might work or at least be easier to debug,
also, you do not need to specify false, because an IF will continue to test the conditions until if finds the first one that is true.
see if this work and feel free to post back with the errors if there are syntax errors.
IF(
[Request Status]="Draft" and [# of WBS codes]>0 and [Customer Access IS Required]=false and [WBS Not Required?]=false,
true,
(([Request Status]="Draft" and [# of WBS codes]=0 and [Customer Access IS Required]=false and [WBS Not Required?]=true)
or
([Request Status]="Draft" and [# of WBS codes]>0 and [Related Position Number]>0 and [WBS Not Required?]=false), true)),
[Request Status]="Draft" and [# of WBS codes]=0 and [Related Position Number]>0 and [WBS Not Required?]=true,
true))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
also, you do not need to specify false, because an IF will continue to test the conditions until if finds the first one that is true.
see if this work and feel free to post back with the errors if there are syntax errors.
IF(
[Request Status]="Draft" and [# of WBS codes]>0 and [Customer Access IS Required]=false and [WBS Not Required?]=false,
true,
(([Request Status]="Draft" and [# of WBS codes]=0 and [Customer Access IS Required]=false and [WBS Not Required?]=true)
or
([Request Status]="Draft" and [# of WBS codes]>0 and [Related Position Number]>0 and [WBS Not Required?]=false), true)),
[Request Status]="Draft" and [# of WBS codes]=0 and [Related Position Number]>0 and [WBS Not Required?]=true,
true))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you, thank you! We've been working on this for over a week. I had to make a few syntax fixes, but it now works in all four cases. Appreciate the background on formulas too. Here's the finished result:
If(
[Request Status]="Draft" and [# of WBS codes]>0 and [Customer Access IS Required]=false and [WBS Not Required?]=false,
true,
(([Request Status]="Draft" and [# of WBS codes]=0 and [Customer Access IS Required]=false and [WBS Not Required?]=true)
or
([Request Status]="Draft" and [# of WBS codes]>0 and [Related Position Number]>0 and [WBS Not Required?]=false)), true,
([Request Status]="Draft" and [# of WBS codes]=0 and [Related Position Number]>0 and [WBS Not Required?]=true),
true)
Thank you again!
Nancy
------------------------------
Nancy Scholl
------------------------------
If(
[Request Status]="Draft" and [# of WBS codes]>0 and [Customer Access IS Required]=false and [WBS Not Required?]=false,
true,
(([Request Status]="Draft" and [# of WBS codes]=0 and [Customer Access IS Required]=false and [WBS Not Required?]=true)
or
([Request Status]="Draft" and [# of WBS codes]>0 and [Related Position Number]>0 and [WBS Not Required?]=false)), true,
([Request Status]="Draft" and [# of WBS codes]=0 and [Related Position Number]>0 and [WBS Not Required?]=true),
true)
Thank you again!
Nancy
------------------------------
Nancy Scholl
------------------------------
- MarkShnier__YouNice lookin' formula.
Much easier to read now and hence easier to debug.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
