I would like to create a new Timeline view using a new Mutli-select field as the grouping field. I would like for this multi-select field to be populated with the values from 3 existing checkbox fields:
I have read a topic (How to map Checkbox fields to Multi Select options) where it says it’s not possible to do this and to use a Formula instead. Does anyone know which formula I should use to achieve what I need which is to use the values of the multi-select as a grouping field in a Timeline view with coloured options for each option?
Alternatively, is it possible to do the reverse, i.e. populate the checkbox fields with the multi-select options (the checkbox fields are used with date fields on a Calendar View).