SOLVED

Carry over cell formatting from source worksheet to destination worksheet generated via LET (TAKE 2?

Brass Contributor

Not sure if the first request is out there somewhere.  

 

I have created a custom format(s) '#0.00 " in"' so when a value is entered, it displays "1.00 in".  Using a LET statement on a destination worksheet, the data is filtered and copied over.  However, the custom format is not copied over.  Is there a way to do this?

 

=LET(
features_tbl, FILTER('pty-linkProductFeatures_Base'!$A$1:$BG$1600, 'pty-linkProductFeatures_Base'!$A1:$A$1600<>""),
data, DROP(DROP(features_tbl, 1, 2),, -1),
keys, DROP(HSTACK(TAKE(features_tbl,, -1), TAKE(features_tbl,, 2)), 1),
specNames, DROP(DROP(TAKE(features_tbl, 1),, 2),, -1),
code, XLOOKUP(specNames, Table_Specifications[Attribute name], Table_Specifications[[Classification Attribute ]], "not found"),
typevalue, XLOOKUP(specNames,Table_Specifications[Attribute name], Table_Specifications[Feature Type], "not found"),
a, SEQUENCE(ROWS(data)),
b, SEQUENCE(, COLUMNS(data)),
CHOOSECOLS(
EXPAND(
HSTACK(
CHOOSEROWS(keys, TOCOL(IF(b,a))),
TOCOL(IF(a,code)),
TOCOL(IF(a,typevalue))&","&TOCOL(data)
),, 7, ""),
2, 3, 4, 5, 6, 7, 1
)
)

 

NotSoFastEddie_0-1716086179172.pngNotSoFastEddie_1-1716086233748.png

 

2 Replies
Try TEXT() function like =TEXT(1,"#0.00")&" in"
best response confirmed by NotSoFastEddie (Brass Contributor)
1 best response

Accepted Solutions
best response confirmed by NotSoFastEddie (Brass Contributor)