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
)
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |