Microvellum Community

Face Frame (Multi Bay) Subassembly Qty Formulas are Slightly Off

There isn't really anything too broken, its just asking for
=IF(Bay_1_Face_Options<>"No Doors",1,0)

While it should be asking for
=IF(Bay_1_Face_Options="No Door",0,1)

The No Doors causes a problem because F Table is giving the drop down selection as No Door.  All the bays are asking the same.  I just copied an example from Frameless vs Frame

Bay 2 example
=IF(OR(Bay_2_Face_Options="No Door",Bay_Qty<2),0,1)
vs
=IF(AND(Bay_2_Face_Options<>"No Doors",Bay_Qty>1),1,0)

etc.

All it does is gives Component No Door FF (Doesn't exist) a quantity of 1 instead of 0.

Thanks,

-James

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.