Kanban Column Field

Hello -

I have a field in my main table called Rank. This field has numeric values starting at 1 and goes up to ~ 1000. It also allows decimals so for example 100.5 or 376.5...etc.

I have a request to make a kanban board with the columns being 'groupings' of the Rank field so for example:

1-100

101-200

201-300

301-400

...

901-1000

I know the field used for the columns must be a multiple-choice field. 

The only method for this I can think of would be to have a formula field to take in the number and return the 'grouping'. Then use a pipeline or automation to populate a multiple-choice field with that grouping, which could then be used in the kanban report.

My concern with this approach is this Rank field is constantly changing, and a majority of the time this field is wiped out and re uploaded with the bulk upload feature and I worry the pipeline/automation would not work consistently for this use case.

I was thinking one solution could be a scheduled pipeline after hours once a day but this would not be preferred since then the kanban would only reflect changes once a day...Is there a better method for what I am trying to achieve?

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------