"Find" formula to look for exact values

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”)

image

Thanks

@Sabu98

***CORRECTED
Try this:
IF(REGEXMATCH({Status}, "(^|.*, )"&"Hole 11"&"(, |$)"), {Monday}/{Status#Count}, "0")


Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– 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.

image

I appreciate very much your help, thank you!

@Sabu98

Oops… not sure what I was thinking.

Try this:
IF(REGEXMATCH({Status}, "(^|.*, )"&"Hole 11"&"(, |$)"), {Monday}/{Status#Count}, "0")


Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– 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

@Sabu98

Try:
IF(REGEXMATCH({Status}, "(^|.*, )" & "Hole 11" & "(, |$)"), {Monday} / IF({Status#Count}, {Status#Count}, 1), "0")


Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

1 Like

Thank you very much!!

1 Like