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:
My goal: Make a fifth column that checks if all Three tasks are completed, so it looks like this:
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: