There may be a solution using the Formula column where you may be able to concatenate the sort data into a single string.
In excell the formula would look something like this:
+=left(a3,3)&b3
This would give the first three characters of cell a3 joined to the whole of b3.
You can combine left right and mid sections of multiple cells.
It works well with leading zeros.
I use this all the time when populating name columns with multiple sections so starting with:
Pipeline K00 > K01 on the first section it is easy to change the next to K01 > K02 right along to K 98 > K99 on the spreadsheet and then copy paste to the whole length - saves a hell of a lot of typing in the barchart.
Thanks for your quick response. Your suggestion is a decent workaround when a project's schedule is finished. However, I'm looking for a generic solution, which can be applied on every (new) project and schedule. Also, I want the solution to keep working when I add new objects and activities, without adjusting the numbers in the blank column suggested by you. Therefore, the solution should include a sorting based on start dates of objects, i.e. the object which includes the activity with the earliest start date of all activities, should be the top of the schedule (within a certain Phase in this example).
I have tried sorting the schedule first on Phase, then on Start Date and lastly on Object. Logically, this sorting will not form groups with activities of the same object, because it will first sort on Start Date and then on Object. See the example below.
[[wysiwyg_imageupload:1827:]]
As mentioned before, in the example of the second image, I want the ‘Precast pile’ group to appear above the ‘Foundation block’ group. Any additional suggestions?
Member for
19 years 10 monthsHi HansThere may be a
Hi Hans
There may be a solution using the Formula column where you may be able to concatenate the sort data into a single string.
In excell the formula would look something like this:
+=left(a3,3)&b3
This would give the first three characters of cell a3 joined to the whole of b3.
You can combine left right and mid sections of multiple cells.
It works well with leading zeros.
I use this all the time when populating name columns with multiple sections so starting with:
Pipeline K00 > K01 on the first section it is easy to change the next to K01 > K02 right along to K 98 > K99 on the spreadsheet and then copy paste to the whole length - saves a hell of a lot of typing in the barchart.
Best regards
Mike Testro
BTW Lotus 123 is far superior to Excell.
Member for
12 years 7 monthsHi Mike,Thanks for your quick
Hi Mike,
Thanks for your quick response. Your suggestion is a decent workaround when a project's schedule is finished. However, I'm looking for a generic solution, which can be applied on every (new) project and schedule. Also, I want the solution to keep working when I add new objects and activities, without adjusting the numbers in the blank column suggested by you. Therefore, the solution should include a sorting based on start dates of objects, i.e. the object which includes the activity with the earliest start date of all activities, should be the top of the schedule (within a certain Phase in this example).
I have tried sorting the schedule first on Phase, then on Start Date and lastly on Object. Logically, this sorting will not form groups with activities of the same object, because it will first sort on Start Date and then on Object. See the example below.
[[wysiwyg_imageupload:1827:]]
As mentioned before, in the example of the second image, I want the ‘Precast pile’ group to appear above the ‘Foundation block’ group. Any additional suggestions?
Member for
19 years 10 monthsHi HansYou can put random
Hi Hans
You can put random sets of numbers in a blank user column and sort on that.
One point - when you copy / paste text numbers from the Asta column to a spreadsheet the revert to numerals.
Best regards
Mike Testro