Conditional formula to editable/readonly columns in Sharepoint List based on the column value

[Masha_Masha]

Hi All,

I want to asked about set sharepoint online column editable/readonly based on the column value.

Example: if field status = draft > editable, if field status = approve > readonly

Thanks,

Masha

[#2 · Accepted solution]

@Masha_Masha 

This is not possible using SharePoint default capabilities. To achieve this you have to customize the list form using Power Apps.

You need to set the DisplayMode property of column data card based on status value something like this:

If(ThisItem.Status.Value = "Draft", DisplayMode.Edit, DisplayMode.View)

Check below examples for more information:

1. Form to 'Read Only' based on Status value column and lookup list 
2. Make some Text Input fields read-only in Edit Forms 

---

Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.