Mike Williams Posted April 30, 2020 Share Posted April 30, 2020 Hi Trying to make a cell that takes data from more than one record and splice them together. Example 'Multicable VW'.'Part 1' = 1m 'Multicable VW'.'Part 2' = 3m Cell 'Multicable VW'.'Part 1' & 'Multicable VW'.'Part 2' = 1m3m What am i doing wrong ? Quote Link to comment
0 Pat Stanford Posted April 30, 2020 Share Posted April 30, 2020 =Concat('Multicable VW'.'Part 1', 'Multicable VW'.'Part 2') Should generate = 1m3m Quote Link to comment
0 Sam Jones Posted April 30, 2020 Share Posted April 30, 2020 I'm unclear as to what you want the resulting cell to be. Quote Link to comment
0 Mike Williams Posted May 1, 2020 Author Share Posted May 1, 2020 @Sam Jones I was attempting to make a string of data from inputs from vw into one cell. In the example i was trying to put the different parts in a cable into the spreadsheet in one cell. This is done for you in the Multi-cable label format but not in any other record format associated with cable types (as far as i can see). I also want to use if for other pieces. I was missing. the function concat(). Is there a cleaner way of doing this. =CONCAT((IF(('Feeder Cable VW'.'Part 1'>0), ('Feeder Cable VW'.'Part 1'), '')), (IF(('Feeder Cable VW'.'Part 1'>0), ('m'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 2'>0), ('Feeder Cable VW'.'Part 2'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 3'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 3'>0), ('Feeder Cable VW'.'Part 3'), '')), (IF(('Feeder Cable VW'.'Part 3'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 4'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 4'>0), ('Feeder Cable VW'.'Part 4'), '')), (IF(('Feeder Cable VW'.'Part 4'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 5'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 5'>0), ('Feeder Cable VW'.'Part 5'), '')), (IF(('Feeder Cable VW'.'Part 5'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 6'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 6'>0), ('Feeder Cable VW'.'Part 6'), '')), (IF(('Feeder Cable VW'.'Part 6'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 7'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 7'>0), ('Feeder Cable VW'.'Part 7'), '')), (IF(('Feeder Cable VW'.'Part 7'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 8'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 8'>0), ('Feeder Cable VW'.'Part 8'), '')), (IF(('Feeder Cable VW'.'Part 8'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 9'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 9'>0), ('Feeder Cable VW'.'Part 9'), '')), (IF(('Feeder Cable VW'.'Part 9'>0), 'm', ''))) (IF(('Feeder Cable VW'.'Part 2'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 2'>0), ('Feeder Cable VW'.'Part 2'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), 'm', '')), which is the 3 if statements added for each of the 9 cable parts. Goal is to create a cell that looks like this 5m+7m+8m if a value exists in the cell. m Quote Link to comment
Question
Mike Williams
Hi Trying to make a cell that takes data from more than one record and splice them together.
Example
'Multicable VW'.'Part 1' = 1m
'Multicable VW'.'Part 2' = 3m
Cell 'Multicable VW'.'Part 1' & 'Multicable VW'.'Part 2' = 1m3m
What am i doing wrong
?
Link to comment
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.