# IF the greatest THEN ... ELSE column?

**URL:** <https://community.glideapps.com/t/if-the-greatest-then-else-column/60510>\
**Category:** Ask for Help\
**Created:** [April 13, 2023, 10:14pm UTC](https://community.glideapps.com/t/if-the-greatest-then-else-column/60510 "2023-04-13T22:14:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lionel\_Janus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lionel_janus/32/29477_2.png) [@Lionel\_Janus](https://community.glideapps.com/u/Lionel_Janus)\
**Post date:** [April 13, 2023, 10:14pm UTC](https://community.glideapps.com/t/if-the-greatest-then-else-column/60510/1 "2023-04-13T22:14:01Z")

</div>

Hello, I am trying to display the greatest value of a column (which could be multiple) through an IF THEN ELSE column but I can’t reach it 😕

I have a number column (number of matchs played) and a text column (Players names).

I would like to display the name(s) of the player(s) with the biggest numbers of matchs played.

I thought I could do that with an IF … then set the Names value Else (empty) but there are only equals, empty, greater than … Such a pity there is no way to find just the greastest or the lowest.

If anyone has a simple answer or work around it would be awesome. I think I can not think with logical at the moment 🙂

Cheers from France,  
Lionel

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 13, 2023, 10:21pm UTC](https://community.glideapps.com/t/if-the-greatest-then-else-column/60510/2 "2023-04-13T22:21:54Z")

</div>

Create a Rollup column to get the max. Then you can set a filter on a collection or create an IF column that compares the players value to the Rollup column.

---

<div class="post-metadata">

**Author:** ![Lionel\_Janus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lionel_janus/32/29477_2.png) [@Lionel\_Janus](https://community.glideapps.com/u/Lionel_Janus)\
**Post date:** [April 14, 2023, 11:10am UTC](https://community.glideapps.com/t/if-the-greatest-then-else-column/60510/3 "2023-04-14T11:10:23Z")

</div>

Thanks a lot I will try this way 🙂