# Expose rank as a writable field in no-code automations

**URL:** <https://community.fibery.io/t/expose-rank-as-a-writable-field-in-no-code-automations/9398>\
**Category:** Ideas & Features\
**Created:** [August 11, 2025, 10:28pm UTC](https://community.fibery.io/t/expose-rank-as-a-writable-field-in-no-code-automations/9398 "2025-08-11T22:28:56Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 13, 2025, 6:47am UTC](https://community.fibery.io/t/expose-rank-as-a-writable-field-in-no-code-automations/9398/9 "2025-08-13T06:47:44Z")

</div>

> [@RonMakesSystems](#):
>
> What if it was the rank of the other one, plus the public ID of the project it created, times 100

Public Ids are text type 🫤

But I suppose you could convert text to number.

I’m not going to recommend any particular method involving rank, because I don’t know the consequences.

I’d simply suggest using a dedicated ‘Order’ field instead.

Note: it is possible to use a formula field to get the relative position of a child entity in a collection:

```auto
(Find(
  [Project].Task.Sort().Join("#" + Right("000" + [Public Id], 4), ""),
  "#" + Right("000" + [Public Id], 4)
) +
  4) /
  5

```

See here:

> [@Formula to assign number based on sorting](https://community.fibery.io/t/formula-to-assign-number-based-on-sorting/3652):
>
> Hi everyone slight_smile Not sure if this is a help request or a formula function request: Is there an elegant way to number up entities in a formula field based on a sorting? If this is not possible, I’d like to request a position() function, which returns the position of an entity within a collection based on a sorting. E.g.: Projects can have tasks assigned, each of which have a start date. If a project has 4 tasks assigned, I would want an auxiliary (formula) field showing 1-4, depen…

---

_[View the full topic](https://community.fibery.io/t/expose-rank-as-a-writable-field-in-no-code-automations/9398)._