Hi everyone! I hope you had an amazing Thanksgiving!
I have some problems with my formula, I'm trying to concatenate two columns (see attachment ). As you can see, the Calculation column missed the "commas" of the originals columns, and moreover, if there is anything in a column, it adds a comma.
Your first two columns are lookup fields. That means that the commas you see in the lookup fields themselves aren't really there. Lookup fields are the most problematic fields to use in formulas. Try turning your lookup fields into rollup fields with the formula
Hi Sara! So sorry, that is nowhere near the correct formula that I was supposed to give you. I was getting some errors trying to reply with the formula and must have somehow messed up sigh. I still can't do so now, but you can duplicate this base I've set up for you and grab the formula from there
Thank you! I really appreciated that you had the time to create a base for me. Your formula works if the column "Report names" is just a text. I tried to use your formula on rollup and on lookup (Unluckily my reports are in one of those formats) and it "eats" the comma between some letters.