Ordering columns in a report group

Shannon Scarbrough

I have a report which is grouped by a a Repair Status column in descending order. I'd rather be able to order the grouping customized which is not an option. One idea is to create a formula column to order the 3 options how I would like, which I think would require multiple IF statements. I want to be able to say

If the repair status column = In progress, then the cell in another column =1, If the repair status column = standy by, then the cell in another column =2, If the repair status column = closed, then the cell in another column =3. And then I can order the columns based on that helper formula column. Any ideas on formula? Thanks!

Paul Newcome

This would be a pretty standard "nested IF" statement.

=IF([Repair Status]@row = "In Progress", 1, IF([Repair Status]@row = "Stand By", 2, 3))

Paul Newcome

This would be a pretty standard "nested IF" statement.

=IF([Repair Status]@row = "In Progress", 1, IF([Repair Status]@row = "Stand By", 2, 3))

Shannon Scarbrough

thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️