Write formula changes, concatenations and hyperlinks in a single line?
Hello, I have a data path and a SharePoint link/URL. I was able to adjust some things in the data path using the switch formula and then combine them using the concatenate formula.
Now my question is: How do I write the formulas together in one line and in such a way that they become a hyperlink?
I've tried a few things, but unfortunately I'm not getting anywhere.
=hyperlink(URL;Displayname)
have it exaggerated with the fragmentation
and the rest usually goes via indirectly linking or, if you are just talking about text, then just linking or quite classically the old-fashioned =”text”&”multitext” ….