Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2017, 12:00 AM
rules rules is offline Highlighting task before start date Windows 10 Highlighting task before start date Office 2016
Novice
Highlighting task before start date
 
Join Date: Nov 2017
Posts: 3
rules is on a distinguished road
Default Highlighting task before start date

Good day all



Been using Project very superficially for the last two years or so but need to start delving a little deeper

Is there a way to get a task to highlight automatically when it gets to a certain date if there has been no action (by using complete % maybe)?

The idea would be to use it as a reminder to oneself. If you perhaps missed a start date and did not indicate any progress after a week then it would get highlighted to indicate inaction. Come to think of it, it would be awesome if you could even get it to highlight with yellow a week before start date and then change to red a week after start date if no action has been indicated.

Thanks
Reply With Quote
  #2  
Old 11-14-2017, 05:26 PM
Guloluseus Guloluseus is offline Highlighting task before start date Windows 7 64bit Highlighting task before start date Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Custom columns will do this. I will assume you donr know how to do these, so the easy steps are:
1. Insert anew column in project, select "number 1" (assuming its not already in use)- doesnt matter which as long as its a number column.
2. right click on the field heading and select "custom fields".
3,. Click on the button that says "formula" and paste the following into the big box at the top
IIf([% Complete]>0,1000,IIf([Start]<[Current Date]-7,3,IIf([Start]<[Current Date],2,IIf([Start]<[Current Date]+7,1,1000))))

4. Go down to "graphical indicators" at the bottom, and fill it in as in the attached piccy.
5. close all windows by clicking OK.

This will give you a visual indicator of a red flag if a task should have started more than 7 days ago, a red dot if it should have started between 7 days ago and now, and an amber indicator if its due to start in the next 7 days. anything else shows as green.

this works by comparing the expected start date to TODAYS date (so that will be the date you open the programme, so if its the 22nd nov when you look at it that will be the date compared to. If there si any progress logged (ie % complete is 1or more %, then the task will be green (progress has been made), if no progress has been logged and it should have started then it will have an indicator.

If this isnt what you needed or you have probs, post back and we see if we can make a better formula for you.
Attached Images
File Type: jpg qqq.JPG (81.9 KB, 14 views)
Reply With Quote
  #3  
Old 11-14-2017, 11:12 PM
rules rules is offline Highlighting task before start date Windows 10 Highlighting task before start date Office 2016
Novice
Highlighting task before start date
 
Join Date: Nov 2017
Posts: 3
rules is on a distinguished road
Default

Hi Guloluseus

Thanks for the response. I am however not getting it to work. Have gone through it a few times now (most of which is because I didn't read properly ... I blame the early morning) and have done exactly as stated but end up with a new column with 0's in it and no flags.

Any ideas of what I could be doing wrong?

Thanks again
Reply With Quote
  #4  
Old 11-17-2017, 06:02 PM
Guloluseus Guloluseus is offline Highlighting task before start date Windows 7 64bit Highlighting task before start date Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

I have uploaded in zip a programme with the column in. If it doesnt show up, insert new column "number 20", and it will show up.
If it works correctly, copy it into your global settings, and then it can be inserted into any programme yu want. If its still giving probs let em knoew- works for me, but may be that you have a setting diffrent somewhere. I have saved as project 07 format, so it should load in whichever version you have.
Attached Files
File Type: zip start marker 2.zip (143.4 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlighting task before start date Showing a Task Start Date Slip Pmacdaddy Project 1 01-26-2017 10:14 AM
Set start and end dates of one task based on one other task only zamshabeer Project 1 07-07-2016 11:25 AM
Highlighting task before start date Start date of successor task does not change raminraiszadeh Project 3 09-19-2015 01:41 PM
How to make a task adjust its end date depending on another task? (Newbie) ravl13 Project 3 07-27-2014 06:10 PM
Task with Start date but no Due date? bplat Outlook 0 01-12-2012 08:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:21 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