I'm working at a small organization which is hosting a third-party application (business software) for our users. The software is quite comprehensive; we are using only a subset of the functionality. On the other side, the software vendor has created some customizations for us. We have the possibility to file tickets with bug reports and feature requests to the software vendor.
When a new software version is released, we want to ensure that
- there are no bugs/regressions in the functionality for our needs
- new features are bug-free
- new features are useful for our needs
Our tests consist mainly of "click field A, click field B, enter asdf, see what happens in field C".
At the moment, we maintain a huge spreadsheet which contains our tests, the expected/actual results, version information, ticket information and comments. As this spreadsheet is growing, it becomes more and more unusable.
What is the recommended solution to keep track of our tests, test results, ticket information etc? Please note that we are a small organization (2-3 technicians).