![]() |
#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!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
oscarlimerick | Excel | 4 | 03-14-2022 12:22 AM |
![]() |
ds1 | Project | 4 | 04-17-2017 01:34 PM |
![]() |
Seftonbarn | Project | 2 | 03-17-2017 04:50 AM |
![]() |
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 |