Expressions in ArcGIS Arcade have the same function as Indirect Expressions in excel

[bhariadi]

Hi All,

What expressions in ArcGIS Arcade have the same function as Indirect Expressions in excel?

Please see the illustration below:

[JohannesLindner]

// SortField: Field to sort the feature set by, e.g. ObjectID

var sort_val = $feature.SortField
var fs = FeatureSetByName($datastore,"YourFeatureset", ["SortField", "ValueField"])
fs = Filter(fs, "SortField < @sort_val")
if(Count(fs) == 0) {
    return $feature.ValueField
}
return First(OrderBy(fs, "SortField DESC")).ValueField