Hi guys,
I've created a very simple spreadsheet to calculate property tax amount. The user needs to input property price. Output is calculated in another column based on a simple formula (property price * city tax rate).
Here is the problem.
I am trying to put it up on our internal website so that staff/employees can input the value. If I embed the entire spreadsheet, regardless of the permission I give them, they cannot enter values in it.
If I publish it as a list, then there are too many steps involved to get the output:
1. Edit
2. Enter value
3. Submit
4. Refresh
We use this calc frequently so it needs to be a quick 2-click process. Could you please help me figure out a simple way of doing this?
Really appreciate everyone's time and help!
Cheers,
Iram
I've created a very simple spreadsheet to calculate property tax amount. The user needs to input property price. Output is calculated in another column based on a simple formula (property price * city tax rate).
Here is the problem.
I am trying to put it up on our internal website so that staff/employees can input the value. If I embed the entire spreadsheet, regardless of the permission I give them, they cannot enter values in it.
If I publish it as a list, then there are too many steps involved to get the output:
1. Edit
2. Enter value
3. Submit
4. Refresh
We use this calc frequently so it needs to be a quick 2-click process. Could you please help me figure out a simple way of doing this?
Really appreciate everyone's time and help!
Cheers,
Iram