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