Read-only columns in Sharepoint library

Question

Is there any way to make a column read only in Sharepoint Library (not in the list)?
I saw articles about list read only columns, but found nothing about library.

Probably it can be done via power automate somehow but I am not sure.
(using Sharepoint online)

Answer 1

Hi @FNU LNU Khristina ,

It can be set via library settings.
1, Create a calculated column [read-only1] with caculation based on the column you want to set to be read-only.

2, Go to Advanced settings-->Allow management of content type.
3, Go to Library settings-->Content Types ,click “Document” .

4, Click “hide1” and Choose “Hiden” ,Then click “OK”.

5, Go to Edit current view ,and show the calculated column [read-only1] instead of the hidden column [hide1] .

This way even if the user go to the quick edit, it cannot edit the column value.

Thanks,
Yanli Jiang

===========================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello @YanliJiangMSFT-7045,

Thank you so much for the detailed reply! I have tried these steps and it worked.
The only question left, is there any way to hide these nulls? So that there will be "-" or just nothing?

there is null if the hidden column is empty
there are 2 columns with the same text if we display the hidden column