Create a formula so that if the status of a column is equal to "Completed" you can no longer change the row, otherwise you can change the row

Hello everybody,

I would like to create a formula so that if the status of a column is equal to “Completed” you can no longer change the row, otherwise you can change the row.

Thanks for your help.

Hi @Axel_Kaprow,

You can include an expression something like below in the Edit system action of the table to which these rows belong.

[Status]<>“Completed”

Please include this expression in the BEHAVIOR section of the Edit system action in the setting " Only if this condition is true".

1 Like