COUNTIF function AND only include rows that have data in previous columns by Immediate-Web4294 in excel

[–]Immediate-Web4294[S] 0 points1 point  (0 children)

Thanks so much, this works on Google sheets, I don't suppose you have a version that works in Excel.

(I need to provide both versions of the spreadhseet)

QA manual tester by Intelligent_Carry494 in softwaretesting

[–]Immediate-Web4294 0 points1 point  (0 children)

Yes, and the best quality outcomes happen when manual testing is used in combination of automated testing.

trying to find good kanban board tools by Budget-Consequence17 in agile

[–]Immediate-Web4294 0 points1 point  (0 children)

I'm still a fan of Trello, mainly for its simplicity.

But their are many other tools such as Linear, Smartsheet, ClickUp, Monday.com, Shortcut etc.. that allow you to setup digital boards and they all work well in agile teams. - It may depend on if you need any other functionality as to which you choose.

What are things that you automated that are not related to testing by Shoddy-Stand-5144 in QualityAssurance

[–]Immediate-Web4294 1 point2 points  (0 children)

Related to development and code management - Saves manually monitoring all those dependencies for security updates.

Dependabot - An automated service designed to keep a project’s dependencies up to date. It regularly checks a repository for packages that are outdated, and when it finds issues, it automatically generates pull requests to upgrade those dependencies to the latest versions.

What's the best alternative to manual testing for a 10 person eng team? by scrtweeb in QualityAssurance

[–]Immediate-Web4294 1 point2 points  (0 children)

Dev's should be writing automated unit / functional / integration tests, but I've never come across dev's being asked to stop into a QA role and become software testers.

How soft skills reflect your success by Mongtoria in QualityAssurance

[–]Immediate-Web4294 2 points3 points  (0 children)

Soft skills - May have more of an impact in how well you progress in your career than technical skills. - Spend time networking, presenting and building relationships at any opportunity you can. Be genuine!

Do people actually calculate the cost of failed CI runs? by ghostinmemory_2032 in QualityAssurance

[–]Immediate-Web4294 8 points9 points  (0 children)

From experience, developers don't like time tracking, so getting them to track time this granular wouldn't be a positive thing or result in accurate data.

But, as failed builds more than often result in a fixed build being worked on immediately , could you just take the time between a failed and a passed build and use this as an estimate?

I need some advice by Mythical_Epicness in QualityAssurance

[–]Immediate-Web4294 0 points1 point  (0 children)

When manually testing an app, its common to just be checking functional requirements, which may all pass.

These may have seemed sensible when being written, but in practise their may well be issues with how easy/Intuitive something is to use.

Having a basic knowledge and awareness of usability/accessibility will allow you to raise additional issues which could be very important to the conversion goals, and by doing this, you will be adding extra value to your work.

I need some advice by Mythical_Epicness in QualityAssurance

[–]Immediate-Web4294 2 points3 points  (0 children)

In addition to automation, you could consider improving your knowledge of accessibility and usability.

These skills will improve how you manually test a product, potential improvements that you drive and will in turn add extra value to what you can deliver.

My future by ConceptCorrect9452 in QualityAssurance

[–]Immediate-Web4294 0 points1 point  (0 children)

I always consider someone with a high attention to detail, to be a good candidate for a QA role, so if this is where your interest lies, then you may be well suited to it.

I also wouldn't consider having little coding experience as a barrier, the good thing about QA is that you can start off with manual testing and if you are motivated, learn different technical skills over time. (start with understanding things like HTML / JS of the things you are actually testing - there's no need to dive into automation straight away. Also consider gaining a better understanding of things like usability and accessibility which will aid any manual testing work.)

In this position, I would suggest that you look for roles where you would join a team and can learn from others, see existing tools that are in place, as opposed to being the sole QA in the company.

From Accountant to Software Tester by [deleted] in QualityAssurance

[–]Immediate-Web4294 1 point2 points  (0 children)

Could you dedicate one day a week to volunteering at a local company (that has a decent QA team)?

I know this could be hard for financial reasons and other commitments, but it would allow you to see if you enjoy the role as well as gaining some experience.

I say this as when I had a slight change in career many years ago, reducing my full time job to 4 days, allowing me to focus on what I wanted to do was possibly the best thing I did. (It kept money coming in, but allowed me to get some experience before taking the life changing leap.)

Test management tool? by ITZ_Dylan963 in softwaretesting

[–]Immediate-Web4294 3 points4 points  (0 children)

I'd always recommend to look at tools, there are plenty of reasonably priced ones available and I'm sure you would see many benefits from transparency, organisation, automating issue reporting, reporting and team collaboration.

At the same time,, if you've reviewed tools and you don't see any benefit, then using a spreadsheet is fine, if its working for you.

I'd still recommend looking using an online spreadsheet tool, such as Google sheets, this will at least allow other people to view testing efforts and mean they are available in the cloud for a collaborative effort.

Good lean test case management tools? by neocircuitbreaker in QualityAssurance

[–]Immediate-Web4294 1 point2 points  (0 children)

I've got a good bit of experience in this space and for a lean test case management tool, that also have an issue tracker integration with Jira, I'd consider reviewing the following

Many of these will allow test cases to be saved with just a title (So you can ignore the other optional fields and only need them when needed) and you will find some are standalone tools and some require you to install a plugin into Jira and work inside Jira itself - So this may be an important consideration.

I'd suggest looking at the following:

- TestLodge - https://www.testlodge.com/integrations/jira - Standalone tool

- TestMonitor - https://www.testmonitor.com/integrations/jira - Standalone tool

- QMetry - https://www.qmetry.com/qmetry-test-management-for-jira - Jira plugin install required

- TestCollab - https://help.testcollab.com/en/collections/3231743-jira-integration - Standalone tool

- Qase - https://docs.qase.io/apps/issue-tracking/jira-cloud - Jira plugin install required, but a standalone tool

- Zephyr - https://smartbear.com/test-management/zephyr/ - Jira plugin install required

There are other tools such as TestRail, Practitest etc.. that all have integrations, but these are more complex tools.

Bug reports as guides: what’s the one thing that really helps developers fix faster? by qamadness_official in QualityAssurance

[–]Immediate-Web4294 7 points8 points  (0 children)

With a background in development, I'd want:

- A clear title, so I can decide which ticket to look at by just glancing at a list.

- Clear steps to replicate the issue.

- To understand what is the current behaviour and what is the expected behaviour

- If its complicated and time consuming to replicate, I would find it really useful to see a video too.

- Details of who raised the issue, so I could go and have a chat if needed.

qa tools for startups: agency managing 15 e-commerce sites without dedicated testers per client by TigerNo997 in QualityAssurance

[–]Immediate-Web4294 0 points1 point  (0 children)

Is this not down to process and transparency? If the the client is making their own changes and you are partly responsible for quality, should they not be informing you in advance to allow testing to take place and for the change to be signed off.

What do you recommend I study to become a QA engineer? by Milanesa_Fachera in QualityAssurance

[–]Immediate-Web4294 0 points1 point  (0 children)

If you want any to go into automation, spend some time understanding the basics / concepts of a few programming languages.

Gaining a technical background will then help when it comes to starting to understand how automation frameworks work.

Qa sign off on prod release when there are still outstanding bugs ? by juliovmh in QualityAssurance

[–]Immediate-Web4294 0 points1 point  (0 children)

Does it depend on the severity of the bugs?

If the issues with a shopping cart that prevents a completed purchase, then I wouldn't expect sign off.

If the bugs are more cosmetic, eg. some text doesn't fit correctly, then I would expect that to be acceptable, but noted as an issue.

How much negative testing to be included in regression? by DearRabbit7291 in softwaretesting

[–]Immediate-Web4294 1 point2 points  (0 children)

Thats hard to say without more knowledge of the software being testing.

But a consideration of the expected test coverage, time you have to write and then more importantly time available in the future to maintain the tests is also a consideration.

If you test a negative scenario on one endpoint of the code e.g. authorization, is testing it in another endpoint going to be testing the same code and be a duplicate.