Sort data in multiple columns in order by date
Hello!
I have an overview sheet where each job is it's own line and each column is a specific milestone I'd like to track that is linked back to the source timeline.
I created a report with just the job names, job number, and then review 1, review2, review 3. Each review column has a date assigned to it (linked from the timeline of that job)
Is there a way to display the dates in order to show the review that is coming up first? so Ideally the new sheet/chart/report would show sometimes like:
Project 1, job #, date, review 1
Project 2, job #, date, review 3
Project 10, job #, date, review 2
Project 1, job #, date, Review 2
Project 4, job#, date, Review 1
Open to all thoughts and suggestions! Thank you!
Best Answer
-
Okay, I think it's possible but far too complicated. You'd have to separate the dates into separate line items then compare them that way.
Sorry I couldn't help :(
Answers
-
Hello @Nicolette Marinos
Yes, in the report you can use the sort button under the report name. Simply choose the date column to sort by and ascending. This should order your data by soonest date.
Hope this helps.
-
Hey @Christian Graf!
Thanks for the reply, The dates I want to sort are currently spread between three columns. So ideally, I'd like those dates to all live in one column in order. Is that possible?!
-
Is there only one date per row?
If so, you could make another date column with the following formula.
=IF(ISBLANK([date1]@row) = 0, [date1]@row, IF(ISBLANK([date2]@row) = 0, [date2]@row, IF(ISBLANK([date3]@row) = 0, [date3]@row)))
This would take the dates across the three columns and merge them into one that you could then use in the report. If you don't want it to show up on the main sheet, you can hide it too.
Does that help, or are the dates arranged differently? If so you can share an image and I can give you a solution.
-
Hey @Christian Graf
I love the idea of that formula and will definitely use that for something else in the future. But yes, there are multiple dates in a row. The report looks more like this:
-
Okay, I think it's possible but far too complicated. You'd have to separate the dates into separate line items then compare them that way.
Sorry I couldn't help :(
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives