Sort data in multiple columns in order by date

Options

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

Answers

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    Options

    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.

  • Nicolette Marinos
    Options

    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?!

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    Options

    @Nicolette Marinos

    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.

  • Nicolette Marinos
    Options

    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:


  • Christian Graf
    Christian Graf ✭✭✭✭✭
    Answer ✓
    Options

    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 :(