Sorting with project status, Active, completed, not started

Shashank

Hi, I'm trying to sort the projects by status. I need the report to list first 'Active' projects, then 'Not Started' and at the end 'Completed'. But when I use sort ascending, it shows 'Active' project then 'Completed' and then 'Not started'.

Can anyone help to get the sorting done as per the need. Active > Not Started > Completed.

Andrée Starå

https://community.smartsheet.com/discussion/122625/sorting-with-project-status-active-completed-not-started

Hi,

I hope you're well and safe!

You need to either add 01, 02, A, B in front of the Status options or add a so-called helper with the same or similar and sort using that.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Andrée Starå

https://community.smartsheet.com/discussion/122625/sorting-with-project-status-active-completed-not-started

Hi,

I hope you're well and safe!

You need to either add 01, 02, A, B in front of the Status options or add a so-called helper with the same or similar and sort using that.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Shashank

Thankyou @Andrée Starå for a quick response. it worked😊… Have a nice day

Andrée Starå

https://community.smartsheet.com/discussion/comment/438296#Comment_438296

Excellent!

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Shashank

Thankyou for a quick response. it worked :)

Andrée Starå

https://community.smartsheet.com/discussion/comment/450012#Comment_450012

You're more than welcome!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!