Forum Discussion
NancyScholl
Qrew Member
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__You
4 years agoQrew Legend
Nice 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
------------------------------
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
------------------------------
Related Content
- 2 months agoJeremyMyer
- 12 days agoDawnRene3
- 10 days agoTonyGonzalez
- 24 days agoShawnSchrotber1