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 |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |