Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2015, 02:13 PM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default how to enter rleated tasks

i am looking for a way to relate tasks to each other, with something OTHER THAN predecessor of successor columns. my purpose is to relate them for informational purposes, not for scheduling calculation. is it possible?
Reply With Quote
  #2  
Old 02-03-2015, 04:05 PM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Consider adding a hyperlink to the ID of the other task. Right click on the task and select "Hyperlink" from the shortcut menu.
Reply With Quote
  #3  
Old 02-04-2015, 02:32 PM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

so is it adding a link? i didnt follow. after selecting hyperlink what must i do? i typed the ID of the other task into the adress field of hyperlink. it was 18. then i inserted a row above that task so now it is 19. but the 18 in the hyperlink didnt change. for example when you assign a predecessor of task #18 to a task, and then if that task later becomes 19, the predecessor now shows 19. is there a way to do this in other coumns or this hyperlink for informational purposes?
Reply With Quote
  #4  
Old 02-04-2015, 03:03 PM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

No, it is adding a hyperlink for navigation. It is not a predecessor or successor. The hyperlink is to the Task ID. If the task ID changes, the hyperlink points to the original ID.

Right click select Hyperlink. Choose Place in this document. Enter the ID.

Control + Click on the Hyperlink indicator in the Indicator column to go to the Task ID.

I do not know of any other method to "relate" tasks to one another other than the methods I have already outlined.
Reply With Quote
  #5  
Old 02-05-2015, 09:08 AM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

ok. this is too bad, as there are many other ways tasks can be related to and affect each other in real world. anyways, thanks for the information.
Reply With Quote
  #6  
Old 02-05-2015, 10:42 AM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

But if tasks are related to one another and affect each other - shouldn't they be linked? Perhaps if you can give me a more concrete example, I can be of more help. Perhaps using filtering on key attributes added to a custom field will work.
Reply With Quote
  #7  
Old 02-05-2015, 11:55 AM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

for example activities dimensionally affect each other. this is to remind me of dimensional coordination required. or access / staging area of one thing affecting other task. these are not schedule calculation. it is extra info for the whole thing. or for example there may be risks to be taken into account or certain codes, which are not even tasks, and they are entered as additional info. many other variables like extra info such as environmental factors, clean up , safety, equipment... to show all picture all in one place, which has the advantage of being on a scheduling program so that everything can be shown time related and info can be searched when desired.
Reply With Quote
  #8  
Old 02-05-2015, 12:13 PM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Consider using spare text fields to capture this additional data. The advantage is you can filter by those "extra info" fields.
Reply With Quote
  #9  
Old 02-05-2015, 02:51 PM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

yes after some thinking i reached to same conclusion here.

also what do you mean by:


"The advantage is you can filter by those "extra info" fields"

do you mean i can filer per each text field, as i will enter info separately in those? (i identified 15 separate text field i need to use, for each of the variables that matters to me)
Reply With Quote
  #10  
Old 02-05-2015, 03:18 PM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Yes. You can also filter on multiple fields using an AND or OR command. So for example filter for Safety AND Equipment.
Reply With Quote
  #11  
Old 02-09-2015, 08:18 AM
ketanco ketanco is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2010 64bit
Expert
how to enter rleated tasks
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

great
i go to Viev>Filter and then select new filter right? and then there is Filter Definition box. It is done there correct?
Reply With Quote
  #12  
Old 02-09-2015, 12:52 PM
JulieS JulieS is offline how to enter rleated tasks Windows 7 64bit how to enter rleated tasks Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Yes. But you can also use Auto Filters on the custom fields you have inserted.

see:

https://support.office.com/en-us/art...c-66ec043acde1
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
correct way to enter tasks ketanco Project 7 02-11-2014 07:42 AM
updating not completed tasks or 0% tasks ketanco Project 3 08-24-2012 05:59 AM
Export Excel tasks into Outlook Tasks (2007 Version on both) crazedmom Excel 0 12-29-2011 07:55 AM
the best way to enter actuals ketanco Project 3 12-26-2011 09:36 AM
how to enter rleated tasks Enter + Alt + Enter is not working inside the text box! why???? Jamal NUMAN Word 3 04-17-2011 05:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 PM.


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