Populate a column based on a specific information in other column

Topic Labels: Formulas
996 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

Follow a similar process described here:

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: