![]() |
|
#1
|
|||
|
|||
|
Hello,
For example if I enter a link such as 4SS+2, the successor column shows it as 4SS+2 days. I do not want it to write "days" there. Because I have limited print space and just because of word "days" I am losing horizontal print area. Is there a way to adjust the display of successor column to say only 4SS+2 here, without writing "days"? |
|
#2
|
||||
|
||||
|
Assuming your schedule looks like this
![]() Add 2 custom text fields (columns), say Text1 & Text2 and rename them Pred & Succ respectively. Then for these 2 new text fields, add the following formulas, Pred = [Predecessors] and Succ = [Successors] ![]() ![]() Your schedule should now show the predecessors & successors in the new columns and crucially, the word days or day is replaced by d. ![]() Now, hide the default Predecessor & Successor columns and your schedule should look like you wanted. ![]() = Planners' Place |
|
#3
|
|||
|
|||
|
A simple google search gives a solution
|
|
#4
|
|||
|
|||
|
Thanks ProjectPlanner, it works!
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
display a change in column cells counting the number of months
|
oscarlimerick | Excel | 4 | 03-14-2022 12:22 AM |
Display an additional date column in Gantt chart
|
ds1 | Project | 4 | 04-17-2017 01:34 PM |
Predecessor and successor on different calendar
|
Seftonbarn | Project | 2 | 03-17-2017 04:50 AM |
Embedded Excel in Powerpoint - custom animation, display column by column
|
andytheanimal | PowerPoint | 2 | 01-20-2015 06:30 AM |
| Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |