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
-
Assuming this formula is in the Finalist row (which is a checkbox field), you simply need =IF([Rank]@row = "1", 1, 0)
Answers
-
Assuming this formula is in the Finalist row (which is a checkbox field), you simply need =IF([Rank]@row = "1", 1, 0)
-
omg, thank you! I was DEFINITELY over complicating it!!!!
Help Article Resources
Categories
Check out the Formula Handbook template!