Using 'Rank' in formulas?

[Chr1sG]

@tpaktop

I would like to get highest ranking tasks to appear on top of my task list to make sure that I do them first without going into project to see the order of completion.

See here for something that might be relevant/interesting

Formula help: How to index one entity in a collection?

See here: A general formula for getting the index of an entity within a collection: (Find(Collection.Entities.Sort([Parameter to sort on]).Join("#" + Right("000" + [Public Id], 4), ""),"#" + Right("000" + [Public Id], 4)) + 4) / 5 I expect it will slow down the formula service if you have a large collection size though