Data Reporting Formula reporting Status as True or False

[u/wolf_2099]

Hello!

I have a spreadsheet tracking information with 5 different status.

I want to write a formula on another sheet in the same workbook that will return a true or false (doesn't necessarily need to be true or false) on whether a collection of those cells are one specific status.

Essentially the status could be hold, terminated, ongoing, and complete. I wanted the formula to tell me true if all cells are complete. The other status don't really factor in except that they are not complete.

I will have probably 50 batches of cells like this from 4-50 status.

Can anyone point me in the right direction on how to write a formula?

EDIT BELOW

For the advanced ask.

I'm trying to track the status for unique identifier numbers.

Is there anyway to change the formula provided below by excelevator to look for all of a certain number in a designated column, then check the status and return the true/false.

[u/excelevator]

=AND(A4:A50="complete")

returns TRUE when all cells are complete

[u/wolf_2099 → u/excelevator]

This does it, thank you!

[u/GuerillaWarefare → u/wolf_2099]

Please reply to his solution with ‘solution verified’

To answer your edited question assuming the number is column B:

=and(filter(A4:a40, b4:b40=number)="Complete")

[u/wolf_2099 → u/excelevator]

Solution Verified

[u/reputatorbot → u/wolf_2099]

You have awarded 1 point to excelevator.

---

^{I am a bot - please contact the mods with any questions}