My App is a project management app. I have a table that contains all active projects which sort by a status field. I want to set up the sorting to align with the project status lifecycle, however I only have the option to sort them alphabetically and the status values are not structured in a way that alphabetical sorting is of any use. Is there a place/way I can set the order in which I want the status’ displayed?
Probably not the neatest solution, but you could simply number the statuses and then sort A-Z - so 1.Started, 2.Progressing, 3.Complete - or you could add a formula field that did something similar - if {status}=’Started’ then 1 etc and then sort on that field.