Your FCS Date creates two dates for your projects - those that have FDW in [newtitle] and those that don't. How should your data handle this? Should it be that if there is an FCS date, it should be assigned to the whole project? Or do you want to filter the sheet so that it only shows [newtitle] having FDW?
sorry for the late response, I've been sick.
I've been doing tests, so I created several fields. For sorting I want to use 'FCS date-sort' field only.
For one Project name, I display different dates on a single line. One of them is the 'FCS date-sort'.
I want to sort the projects using this date only.
Hope it's clearer.
Hi Myriam, no worries. I think I understand what you're trying to do. Try this.
You were getting two rows per project before, because your FSC date produces two values per project: Null and the FCS date. You need the FCS Date to be assigned to the project - at the project level. So I created a FIXED calculation called FCS Date new to do that.
For the sort, I made it so that whether sorting ascending or descending, the NULL FSC dates always go to the bottom. I'm not sure if that's what you intended.
The workbook is attached.
Hope this helps,
sortByFCS.twbx 53.3 KB