hello
i am stumbling with this issue: i have sheet like this, on the device tabs i am filling Fails and Passes and i need a formula for the main tab that will check the other sheets and return fail if any of them contain fail or pass if all are passes (or not present) for each language into main sheet, not all the issues from the main sheet appear on all the device sheets.
is there a way to do this please?
i am stumbling with this issue: i have sheet like this, on the device tabs i am filling Fails and Passes and i need a formula for the main tab that will check the other sheets and return fail if any of them contain fail or pass if all are passes (or not present) for each language into main sheet, not all the issues from the main sheet appear on all the device sheets.
is there a way to do this please?