How to add another column to a virtual column? (Add a column distance between two locations)

[ASSY]

I have 2 virtual columns:

• Top 5

IFS(NOT(ISBLANK([Coordinates (Lat, Long)])),
TOP(
ORDERBY(
FILTER("No INACTIVE Status", TRUE),
DISTANCE(
[_THISROW].[Coordinates (Lat, Long)],
[Coordinates (Lat, Long)]
)
),
5
))

• Nearest PLA ID

FILTER(
"UDB Datasource 1.0",
IN(
[PLA ID], [Top 5])
)

I want to add another column in the Nearest PLA ID table to indicate the exact distance between 2 locations.

[Markus_Malessa]

Have you tried DISTANCE()? See the link to the documentation below.

https://support.google.com/appsheet/answer/11587699?hl=en