searching column for value to do checkbox
I'm trying to set up notifications for milestones that my team hits, looking for a specific ticket # in a column to send a notification when this ticket # is hit (for example, "Hey team, we just closed our 150,000th ticket. Amazing work, everybody!!"). I have tried using a checkbox column with formulas like the below without success:
- =IF([Issue Key]:[Issue Key] = "MD-150000", 1, 0)
- In the above, "Issue Key" is the column I'm looking to find the specific value within.
- =IF([Column5] = "MD-150000", 1, 0) / =IF([Column5]1 = "MD-150000", 1, 0)
- I found an "answer" on this space showing a way to look at a "Column" but this hasn't worked for me either (I'm wondering if I'm maybe just looking at the wrong 'column' -> "Issue Key" is the first column in my sheet with data, would this be "Column1", and should you be able to say "look in this column" to find a value?
When I look for a value in a specific cell, it does work; like:
=IF([Issue Key]486 = "MD-150000", 1, 0)
Any help that folks are able to provide will be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!