I have my table1 with a list Column A : Client (example : EDF) Column B : Salesperson associated to the client I have my table2 on another sheet. The sales person types in the name of the client everyday, but it is sometimes surrounded with other words (example : "Groupe EDF", or "EDF LYON"). I would like a formula to…
Hi, I would like to extract an email address in a text, knowing that the email address could be in at the beggining of the text, in the midldle of the text, at the end. I have tried formulas with MID, to extract what's before and after the character "@" but I can't find a way to do it on smartsheet, without TRIM ou REPT.…
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
