#16
|
|||
|
|||
Moving columns around is really simple when using defined Tables!
Select whole column (click on column label at top of page, eg. G for DueDate column); Holding down Shift key, place mouse cursor over either of column left or right borders (crossed arrows are displayed), press down left key, and drag the column to new location (formula(s) in moved column remain unchanged); Release mouse key and Shift key. To add new column (e.g. SentForReview), simply insert a new column into wanted position, and then edit column header. After that: 1. you can enter formula into new column, when this is meant for this column; 2. you can enter values into new column, when this is meant for this column; 3. you can edit existing formulas in other columns to take into account added column. I moved DueDate and added SentForReview columns. And I edited formulas in other columns so they can cope with empty rows in Table. |
#17
|
|||
|
|||
Again, made it over a week this time!
I've added a new worksheet, DIREPs. This sheet will track a different set of objects, but using the same base calculations. I got the dropdown to select the doctype set up correctly, but the calculations don't seem to be working. Last edited by jthomas666; 04-06-2020 at 08:56 AM. Reason: forgot attachment |
#18
|
|||
|
|||
From your example and from formulas on sheet DIREPs, it looks like DIREP is additional characteristic of document - parallel with DocClass. When this is the case, then you don't need additional sheet, but you need additional columns for DIREP indo in documents table.
At same time, from you having DIREP types listed in dropdown of DocClass, this assumes DIREP type are another document classes like release, training, etc. When this is the case, then a document can have only one of them selected - this means you need additional helper columns after column DCM in documents table. And again - no need for separate DIREP table. |
#19
|
|||
|
|||
Actually, DIREPs are software fixes, not documents. There is some overlap with the documents in terms of the tracking information needed.
I might be able to fit the direps into the document sheet...I'll see what I can come up with. |
#20
|
|||
|
|||
sigh. I am missing something very basic on how this spreadsheet calculates dates.
trying to calculate Due Dates for specific project documents: CDRLs=SRS/STP DocClass=Projects Due Types Calendar Day (CD) Should be very simple--Base Date = 30 not working. I can't figure out if the problem is with the DueType or if it's somewhere in the helper columns. Suggestions? As always, thank you so much for your assistance. Jim |
#21
|
|||
|
|||
Due Date is empty!
|
#22
|
|||
|
|||
That's the problem--It should have been calculated (as June 11, 2020) when I entered the Base Date.
|
#23
|
|||
|
|||
In attached workbook are column names switched for couple of columns formulas did refer to wrong column), and the formula in one column is corrected
|
#24
|
|||
|
|||
There appear to be some issues with the new file:
1. Column P4--p26 have the wrong values. Not sure what's going on here. 2. The due date for projects is still not calculating. (see row 32 for an example) thanks, jim |
#25
|
|||
|
|||
I don't think I can help much currently. My hand and shoulder are hurting over 5 weeks for now, and typing anything or clicking mouse is a lot of pain.
|
#26
|
|||
|
|||
Quote:
Take care of yourself! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summriez all worksheet in summary work sheet | MILADREZAEE | Excel | 7 | 05-21-2018 05:01 AM |
How to calculate summary progress date time on summary tasks | Logotip | Project | 0 | 05-16-2017 01:18 AM |
Creating a dynamic summary sheet | FenelonPaul | Excel | 5 | 09-23-2015 07:11 AM |
Can a Data Source be one sheet in a multi-sheet Workbook | nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
Construct a summary sheet by summing up from one or more than one sheet. | PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |