Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 75
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
 



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 12:38 AM.


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