Forum Discussion
Solved
clarification on renaming subprojects
Hello to all,
I would like to ask for a clarification on the renaming of subprojects.
In few words, when I create a subproject with a link to a file, a name of an old project of mine appears as the subproject name.
It seems that somewhere in the linked file that old name is stored there.
To be renamed, I have to do it twice:
- renaming first time
- saving and as result, it is restored the old name
- renaming again
- saving succesful.
Do You know where come from the information on the task name of the subprojects?
Thanks in advance
Demetriobbretton61 There is a rather simple solution that might be possible, using the TOROW and WRAPROWS functions, but it all depends on the consistency of your data...
1) Does every invoice row always have an accompanying payment row directly below it?
2) Is there ever more than one payment row per invoice?
3) Are there any blank rows that separate each invoice? If so, is the number of blank rows per invoice consistent for the entire data range?
Assuming the total number of rows per invoice is consistent throughout the entire spreadsheet, the following two examples would work.
Example 1: Data contains a consistent number of invoice and payment details
A B C D 1
INV001 11/01/2023 John Smith 2,500.00 2 Visa 2,500.00 3 4
INV002 11/02/2023 Jane Doe 1,500.00 5 Debit 1,500.00 6 In this example, since there are a consistent number of invoice details (4), as well as payment details (2), the following formula can be used to return all 6 items to one row for each invoice:
=WRAPROWS(TOROW(A1:D6, 1), 6)The TOROW function takes all of the data from the selected range and moves it to a single row. The optional [ignore] argument in this case is set to 1 to ignore blanks. The wrap_count argument of WRAPROWS is set to 6 to return a total of 6 items per row.
Example 2: Data contains a variable number of invoice or payment details
A B C D 1
INV001 11/01/2023 John Smith 2,500.00 2 Visa 1,250.00 MasterCard 1,250.00 3 4
INV002 11/02/2023 Jane Doe 1,500.00 5 Debit 1,500.00 6 In this example, since the total number of items varies for each invoice, the formula must be modified as follows:
=WRAPROWS(TOROW(A1:D6), 12)In order to return a consistent number of items per invoice, the optional [ignore] argument could not be used in this case. Instead, the wrap_count was determined by multiplying the number of columns in the data range by the number of rows per invoice, including blank rows (4 x 3 = 12). If there were no blank rows in the above example, the wrap_count would have been 8.
Note: any blank cells from the original data range will be filled with zeros in the resulting array.
4 Replies
- Demetrio,
I assume you are referring to the subproject name as it appears in the task Name field in the master file. That name is NOT the name of the file (as saved or renamed), rather it is the name associated with the Project Summary Task of the subproject (i.e. subproject task ID 0).
However, if you are working with linked structures in Project (e.g. master/subprojects) you need to be aware of some unwritten rules to avoid corruption of the structure. Never rename, move, overwrite or "save off" to another location any of the files in the structure. Ideally all files should be in a single directory on a local drive and not be operated over a network.
John- John,
I agree with You
Thanks a lot for your warning
demetrio
- demestrio61 --
I can tell you EXACTLY where the subproject name is coming from. Open one of the troublesome subprojects. Click File > Info. In the upper right corner of the Info page, click the Project Information pick list button and select the Advanced Properties item. In the Properties dialog, enter the correct name of the project in the Title field and then click the OK button. Save and close the project. You will need to repeat this process for each of your subprojects. After doing so, when you open your master project, you will see the correct name of each subproject. Hope this helps.- Perfect!
Demetrio
