IF Statement to check a box


I feel like this is so simple but for some reason, I just can't figure it out!!

I have a smartsheet where we're ranking applicants. They can get a highest score of 60. I have a column named "Rank" that has a formula in it that breaks them into Rank "1", Rank "2" or Rank "3" dependent on their final score. When "1" is listed in the Rank column, I'd like the check box in the "Finalist" column to be checked. This will automatically trigger the conditional formatting to highlight it (this is also already set up). I just can't get that stinking IF statement to work!! This is what I tried so far:

=IF([Rank]@row = "1", [Finalist]@row = "1")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!