Only display Last Version

[yann_blondel]

Hello All! Not sure I should ask this question in Formulas. On a list of multiple versions of a same item I’d like to only display the last one.
Here is what I have:

Here what I wish to obtain:

Thanks in advance!

[Kamille_Parks]

Sounds like you need two tables: one for Items and one for Versions.

Items would have to records: ABC_ABV and ABC_ACB. Each of those records would be linked to all the associated versions. Then from there you could use rollups/lookups to display in the Items table the {Version Name} of the most recent version. Refer to this thread for an example

Populate a column based on a specific information in other column Formulas

Hi all, Here is a screen of what I want to do automatically: [Capture d’écran de 2021-06-03 17-54-20] For an example, I have a application with the name “gazelle-evsclient”. This application can be have multiple version (ex: 5.13.1, 5.13.0, …). I want to create a column (ex: Need to be upgrade) based maybe on a formula who say: “If the actual version is not the latest, so I display the latest version for this application”. It is possible to do that ? Thx for your help ! :slight_smile: