FEATURE REQUEST: Defined Ranges for Spreadsheet Columns
It would be great if the other columns in the spreadsheets (CutParts, Hardware, Subassemblies) were defined ranges - similar to the defined ranges for Panel_Width, Panel_Length, Panel_Qty. This would be helpful too for all the hidden columns (A thru P), especially Perfect Grain, Part Grain Override, etc.
Having the columns be defined ranges just adds to the power and ease of writing formulas, particularly formulas that reference information specific to the row. For example, a formula for part comments: =IF(Part_Grain_Override=4,"Grain has been set to Force Width",""). A formula like that (which can be pasted in any cell on any row) could be used to help determine on a part label if the engineer forced graining - this would help in WO review when you see a part that has been marked as "rotated" on grained material. Normally, that is a red flag during review, but if the part label has states that the grain has been forced manually, I'd know that it was done intentionally.
Take the Survey
Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.
Having the columns be defined ranges just adds to the power and ease of writing formulas, particularly formulas that reference information specific to the row. For example, a formula for part comments: =IF(Part_Grain_Override=4,"Grain has been set to Force Width",""). A formula like that (which can be pasted in any cell on any row) could be used to help determine on a part label if the engineer forced graining - this would help in WO review when you see a part that has been marked as "rotated" on grained material. Normally, that is a red flag during review, but if the part label has states that the grain has been forced manually, I'd know that it was done intentionally.
Instead, users are forced to use functions like INDIRECT("J" & ROW()) to get a formula like state above to work on any cell in any row.
Topic Participants
James Drury @ Master Millwork
Toolbox BSB Survey
Have you been using Toolbox BSB? We'd love to hear what you think!
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: