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

Question

Hi All,

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

Please see the illustration below:

JohannesLindner · Answer

// 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