Nov 18 2022 11:48 AM
So I have a row of fields and most will contain a number that to me has a value assigned to it. The value is not important and will be manipulated elsewhere. What I need is a summary of those values (essentially creating a code that acts as a roadmap. So I may enter a number in 5 fields but leave 3 empty because they do not apply, but still need it to fill into the overall "summary" value for the empty field.
Code 1 | Code 2 | Code 4 | Code 5 | Code 6 | Code 7 | Size | Code 8 | Code 9 | Code Summary | |
1 | 2XL | 1.2XL | I need every field accounted for | |||||||
1 | 3XL | 1......3XL.. | This doesn’t work either | |||||||
1 | 3XL | 1.0.0.0.0.0.3XL.0.0 | This is what I need it to come out like | |||||||
1 | Small |
Nov 18 2022 12:10 PM
Solution=TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))
You can try this formula which returns the intended result in my sheet.
Nov 18 2022 12:44 PM
Nov 18 2022 12:10 PM
Solution=TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))
You can try this formula which returns the intended result in my sheet.