I’m trying to build a formula where the column Dup of Formula 1, finds the exact name I’m looking for and then divide the number of hours worked on monday by the count of labels in status.
This is what I have so far, which is working but for example if I’m looking for Hole 1 it also returns Hole 11. Is there a way it finds and matches the text that I’m looking for?
It work!! Now I have another issue, do you know how the formula can also detect second or third labels? Example, I change the formula to look for every “Project Set Up” label, although as you can see in the first item, it is not detecting the label since it’s the second label.