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: 11
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: 11
tropaj is on a distinguished road
Default

Thanks ProjectPlanner, it works!
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:17 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