IF the greatest THEN ... ELSE column?

1

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 :confused:

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 :slight_smile:

Cheers from France,
Lionel

2

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.

2 Likes
3

Thanks a lot I will try this way :slight_smile:

1 Like