Populate a column based on a specific information in other column

[Benjamin_Carrio]

Hi all,

Here is a screen of what I want to do automatically:

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 ! :slightly_smiling_face:

[Kamille_Parks]

Follow a similar process described here:

Get and show latest status by person via form & view Ask the community

It’s been covered a few times here: Team Members Table: get a Rollup field to show the MAX(values) of the {Date of Entry} field Status Messages Table: get a Lookup field of that^ Rollup field. Status Messages Table: get a Formula field that does IF({Date of Entry} = {Lookup field}, 1, 0) Filter your view by where the Formula field = 1

In your case, you may need a Formula field to convert {Version Number} into an actual number so you can get the maximum.

This general idea was also covered on the BuiltOnAir podcast in Season 8, Episode 2: