Hi all
In an assembly drawing, I would like to add a column in the nomenclature table.
example:
a column "total weight" = Qty x Weight of the part
A "cost column" = Qty x Unit costs
...
I manage to insert my formulas into one cell.
But how do you propagate the formula to an entire column? (like an Excel spreadsheet!)
Because on a BOM of more than 100 pieces, I can't see myself filling in my formulas on each of the lines!
Thank you
Hello
Leave the cells blank and enter the formula in the column header (the header colored with the letter).
For example, 'QTE'*'COUT' will display in each cell of the column the result, for each row, of the QTE column multiplied by the COST column.
Hello
Indeed, this allows you to assign the formula to the entire column.
But I would like to be able to "stretch" (like excel) on a few cells. or at least copy/paste "formula format".
I don't think you can extend a formula to the Excel.
However, it is possible to add a condition so that the formula only shows you the result in certain cases with an IF or several ifs depending on another column.
I published the condition as an image because otherwise Lynkoa would detect a virus attempt...
Want to exclude certain cells from the column? Astonishing, but let's admit it.
Either you subject the formula to conditions, as mentioned @sbadenis , but there must be a common point between the cells,
Either youcan enter the formula in the column (the formula that is supposed to have the most occurrences) and then select the cells (click and drag, or with ctrl, shift keys) to exclude, then enter what you want to display there, for example "-" or a different formula.
