Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2022, 05:28 AM
tropaj tropaj is offline Display of predecessor and successor column Windows 10 Display of predecessor and successor column Office 2007
Novice
Display of predecessor and successor column
 
Join Date: Nov 2017
Posts: 12
tropaj is on a distinguished road
Default Display of predecessor and successor column

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"?
Reply With Quote
  #2  
Old 03-19-2022, 11:50 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Display of predecessor and successor column Windows 10 Display of predecessor and successor column Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 03-29-2022, 01:13 PM
JolantaAgata JolantaAgata is offline Display of predecessor and successor column Windows 10 Display of predecessor and successor column Office 2016
Novice
 
Join Date: Mar 2022
Posts: 1
JolantaAgata is on a distinguished road
Default

A simple google search gives a solution
Reply With Quote
  #4  
Old 04-03-2022, 04:12 PM
tropaj tropaj is offline Display of predecessor and successor column Windows 10 Display of predecessor and successor column Office 2007
Novice
Display of predecessor and successor column
 
Join Date: Nov 2017
Posts: 12
tropaj is on a distinguished road
Default

Thanks ProjectPlanner, it works!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Display of predecessor and successor column display a change in column cells counting the number of months oscarlimerick Excel 4 03-14-2022 12:22 AM
Display of predecessor and successor column Display an additional date column in Gantt chart ds1 Project 4 04-17-2017 01:34 PM
Display of predecessor and successor column Predecessor and successor on different calendar Seftonbarn Project 2 03-17-2017 04:50 AM
Display of predecessor and successor column 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft