how to find highest value from 2 collumn

[gregoriusaryant]

hello.... i have problem how to find highest value from 2  or 3 column like this

      row      Date      name       attempt

•     11/14/2023  name a    2
•     11/14/2023  name b    2
•     11/14/2023  name c    2
•     11/12/2023  name  b   1
•     11/10/2023  name a    1

what would i want is get highest value in attempt column based on / refference by name.

can anyone help me with the formula?

big thanks.

[scott192]

If you have a table that stores all of your names.  And you have a table that stores all of your attempts.  And the name column in your attempts is a Ref back to your KEY column in names.  Then:

On your Names table Appsheet will create a [Related Attempts] virtual column that holds (for each name in your table) all of the attempts for that name.

You can access the count of how many attempts using Count([Related Attempts])
You can access the Maximum value from any date or numeric value in Attempts by using MAX([Related Attempts][A date or Numeric Column])

[gregoriusaryant]

thankyou @scott192 i'll try