Hi,
This is my first question on this forum, I tried to find an answer to my problem but was so far unable to…
So, I have this formula IFS(
[Type]=“Entrée”,
CONCATENATE (“1”,
YEAR(TODAY())-2000,
“-”,
LOOKUP([_THISROW].[Nom/couleur],“Codes_barres”,“Nom/couleur”,“Num_Fab”),
“-”,
LOOKUP([_THISROW].[Nom/couleur],“Codes_barres”,“Nom/couleur”,“Num_ref”),
“-”,
WEEKNUM(TODAY()),
“-”,
DAY(TODAY()),
“-”,
[Numéro]),
[Type]=“Fille”,
CONCATENATE (
[Num_rouleau_parent],
“-”,
“F”,
“-”,
[Numéro_fille])
)
For the occurence “Entrée”, I get a hidden apostrophe in the Google Sheets table.
PS: the Type of the column is Text
2 quick statements:
Is Nom/couleur a ref to Codes_barres? if it is you can simply use dereferencing to get your values which is faster.
A solution to try to get a quick fix would be surrounding the whole expression in SUBSTITUTE(“apostrophe”, “”)
I think this would be some sort of bug since you’re concatenating “1” onto the front.
Thanks.
Actually, your last sentence provided me with a fix to this “bug”: I’ve tried co concatenate with “A” onto the front and it didn’t create the hidden apostrophe. So, it’s kind of stupid, but I will do this systematically, then remove the “A” and my problem will be solved
Thanks again !
Gérard
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |