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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!