Quickbase ranking based on field value

Try something like this as a formula checkbox for Invalid ranking.

Set  the four college rank fields to not treat null as zero.

not isnull([College 1 Rank]) and  [College 1 Rank] = [College 2 Rank]
or
not isnull([College 1 Rank]) and  [College 1 Rank] = [College 3 Rank]
or
not isnull([College 1 Rank]) and  [College 1 Rank] = [College 4 Rank]
or

not isnull([College 2 Rank]) and  [College 2 Rank] = [College 3 Rank]
or
=not isnull([College 2 Rank]) and  [College 2 Rank] = [College 4 Rank]
or


not isnull([College 3 Rank]) and  [College 3 Rank] = [College 4 Rank]


Then use form rules or enable Custom Data Rules in Advanced Settings for the table to block the save if that is checked.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------