hrdpgajjar
New Member
- Joined
- Apr 5, 2021
- Messages
- 26
- Office Version
- 2021
- Platform
- Windows
Hi there,
I've a fittings material sheet. I have locked the maximum items additions on the base of an area field. I have set data validation rules as under,
for example :
if area is 1.0 then total allowed fitting material cost is 2000 Rs. whenever user tries to enter more items or the total cost goes beyond 2000 the data validation will not able to enter more amount or items.
All this calculations are based on entering area only.
Now my problem is, other employees do the trick here. they first enter larger area, say for 10.00 and enter all the material accordingly and then save back the area to 1.00.
My question is, how can i stop users from doing this.
i.e. all calculation must be done again when user finally saves the fitting sheet.
help appreciated
Thanks
I've a fittings material sheet. I have locked the maximum items additions on the base of an area field. I have set data validation rules as under,
for example :
if area is 1.0 then total allowed fitting material cost is 2000 Rs. whenever user tries to enter more items or the total cost goes beyond 2000 the data validation will not able to enter more amount or items.
All this calculations are based on entering area only.
Now my problem is, other employees do the trick here. they first enter larger area, say for 10.00 and enter all the material accordingly and then save back the area to 1.00.
My question is, how can i stop users from doing this.
i.e. all calculation must be done again when user finally saves the fitting sheet.
help appreciated
Thanks