Unable to add a new row without missing data

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
)
2 Likes