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.

(1 votes)
Loading...

Similar Posts

Subscribe
Notify of
1 Answer
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Gipfelstuermer
8 months ago

=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” ….