IF Statement to check a box

JPavlasek

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

Adam Murphy

Assuming this formula is in the Finalist row (which is a checkbox field), you simply need =IF([Rank]@row = "1", 1, 0)

Adam Murphy

Assuming this formula is in the Finalist row (which is a checkbox field), you simply need =IF([Rank]@row = "1", 1, 0)

JPavlasek

omg, thank you! I was DEFINITELY over complicating it!!!!