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.

 

Thanks!


Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!