is it possible to assign Link to Item to a Calculated Column in SharePoint Online? I have read a few solutions suggesting editing AllItems.aspx in SPD designer but the calculated column is not listed in the code
Asked
Active
Viewed 4,188 times
2 Answers
1
For SharePoint Online you can use column formatting.
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
For something like creating a hyperlink this is perfect as you likely do not need to store the underlying value.
James Randal
- 1,290
- 2
- 10
- 23
0
You can CONCATENATE an a tag at the calculated column formula
Something like this Ref
=CONCATENATE("<a href="http://server/sitename/Page.aspx?PageTitle=",Title,">",Title,"</a>")
But you must use the available fields that listed when you build your formula. and unfortunately the Link To Item require ID field that is not available !
Check also @Danny answer at Calculated column with ID removes ID number on update , URL in calculated column
Mohamed El-Qassas MVP
- 45,382
- 9
- 53
- 96
-
Have you tested this? – Danny '365CSI' Engelman Aug 31 '16 at 06:51
-
unfortunately no , I depend on the reference , let me check it and if it is not worked I will update/delete it , thanks @Danny'365CSI'Engelman – Mohamed El-Qassas MVP Aug 31 '16 at 07:22
-
ID doesn't always do what you want, See the answer at http://sharepoint.stackexchange.com/questions/159962/calculated-column-with-id-removes-id-number-on-update – Danny '365CSI' Engelman Aug 31 '16 at 07:27
-
you are right so let me update it, many thanks @Danny'365CSI'Engelman for this information – Mohamed El-Qassas MVP Aug 31 '16 at 07:29