Formula error
Please help me make this work...thx
If( [BUDGET.030123]=true, [Job - Copy of Related Projects - Window Wrap-0 Sides]=true, ([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Bo...
Forum Discussion
It looks like you're trying to chain together multiple pieces in the IF criteria, but the way that you're doing it won't work. Here's what I'm seeing:
IF(Criteria 1, Criteria 2, Then,
Criteria 3, Then,
Criteria 4, Then,
Criteria 5, Then,
Criteria 6, Then,
Criteria 7, Then)
If you want to have Criteria 1 and 2 be required for the first Then, that would be:
IF(Criteria 1 AND Criteria 2, Then,
Criteria 3, Then,
Criteria 4, Then,
Criteria 5, Then,
Criteria 6, Then,
Criteria 7, Then)
------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------