Hello,
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?
if(find(“Hole 1”, {Status}, 1), {Monday}/{Status#Count}, “0”)
Thanks
***CORRECTED
Try this:
IF(REGEXMATCH({Status}, "(^|.*, )"&"Hole 11"&"(, |$)"), {Monday}/{Status#Count}, "0")
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic 
– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday
Hello!
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.
I appreciate very much your help, thank you!
Oops… not sure what I was thinking.
Try this:
IF(REGEXMATCH({Status}, "(^|.*, )"&"Hole 11"&"(, |$)"), {Monday}/{Status#Count}, "0")
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday
You’re a genius!
Thank you very much
One last question, is there a way to avoid errors whenever there’s not a label in the status column?
Thanks
Try:
IF(REGEXMATCH({Status}, "(^|.*, )" & "Hole 11" & "(, |$)"), {Monday} / IF({Status#Count}, {Status#Count}, 1), "0")
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday
Thank you very much!!