I am new to app sheet, bear with me. I have a list of existing customers( their bill due date, pending amount , collection amount etc). I want the sales people to only edit the collection. But since ive made all the columns non -editable (except for the collection) . I am unable to add a new customer using action because the columns are uneditable.
You can use below expression with all columns’ Editable_If expression except the column you want to remain editable:
IFS( "your_own_account_email" = USEREMAIL(),TRUE, IN([KeyColumn], TableName[KeyColumn]),FALSE )