I have created a column that looks up from a list. It can return multiple checkbox values and one of the additionally included carry-over columns is numeric. Context: Assembly A and Assembly N are selected. Their values from the 2016 part count column are 170 and 30 respectively. The value placed in the primary column is "Assembly A; Assembly B". The additional carry over column has "170; 30".
I would like to add the numbers separated by the semi-colon into a single calculated 200 value. I'm hoping that I can do this with an inline function. I've tried replace and I just can't seem to get the syntax right. Has anyone done anything similar and had luck with the inline function? Essentially, it will store in a variable and populate a total part count column. I just need some additional imaginations on this. Thank you!