Check if values in each row of array are the same

[noctash]

I have a dynamic array that looks like the following on "Sheet 1". The number of samples is referenced from another sheet ("Sheet 2") and linked to a form, such that if I use the form to add another row, it will automatically update on "Sheet 1" with all tasks marked incomplete.

This is only relevant to say the example below is a variable number of rows at any given time.

Example:

	Task 1	Task 2	Task 3
Sample 1	Done	Incomplete	Done
Sample 2	Done	Done	Done
Sample 3	Done	Done	Done

My goal: Make a fifth column that checks if all Three tasks are completed, so it looks like this:

 

[noctash]

	Task 1	Task 2	Task 3	Tasks done?
Sample 1	Done	Incomplete	Done	No
Sample 2	Done	Done	Done	Yes
Sample 3	Done	Done	Done	Yes

The key being that I want it to be dynamic, so I do not have to drag down every time I add a fourth sample to the reference sheet.

(Sorry for the incomplete message, I can't seem to edit the initial post)

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	Sample 1	Done	Incomplete	Done	No
3	Sample 2	Done	Done	Done	Yes
4	Sample 3	Done	Done	Done	Yes
Details

Cell Formulas
Range	Formula
A2:D4	A2	=Q2:T4
E2:E4	E2	=BYROW(A2#,LAMBDA(br,IF(SUM(--(br="Done"))=3,"Yes","No")))
Dynamic array formulas.

 

[noctash]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	Sample 1	Done	Incomplete	Done	No
3	Sample 2	Done	Done	Done	Yes
4	Sample 3	Done	Done	Done	Yes
Details

Cell Formulas
Range	Formula
A2:D4	A2	=Q2:T4
E2:E4	E2	=BYROW(A2#,LAMBDA(br,IF(SUM(--(br="Done"))=3,"Yes","No")))
Dynamic array formulas.

This is great! Thank you so much!
Going to look more into the syntax of this, this is really helpful for my project.

 

[Fluff]

Glad to help & thanks for the feedback.