I am trying to have my app let me know when I am using too much of a product. I figured if I could set a limit for each type of product on another sheet and have it reference the original sheets column I could get that to work. I am also looking at data validation trying to come up with a formula that would work there, but to no avail. I am just not sure how to make the app work around this. Any ideas?
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |