Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2021, 06:50 AM
Quinn87 Quinn87 is offline Graphical indicator formula for MS Project Windows 7 64bit Graphical indicator formula for MS Project Office 2019
Novice
Graphical indicator formula for MS Project
 
Join Date: Mar 2021
Posts: 1
Quinn87 is on a distinguished road
Lightbulb Graphical indicator formula for MS Project

Hi everyone. I am trying to create a formula to show my project's status using graphical indicators. I would like to show:



If task is 100% complete = Green
If task is not 100% and is passed the date it was due to finish = Red
If task is due in the next 14 days and is under 80% complete = amber
If task has not started = white

I have tried many examples online but can't seem to get any to work.

Any wizards out there i would really appreciate your help.
Reply With Quote
  #2  
Old 03-25-2021, 11:14 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Graphical indicator formula for MS Project Windows 10 Graphical indicator formula for MS Project Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default Is this what you are after?



Is this what you are after?
Reply With Quote
  #3  
Old 03-28-2021, 11:38 PM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Graphical indicator formula for MS Project Windows 10 Graphical indicator formula for MS Project Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Quote:
Originally Posted by ProjectPlanner View Post


Is this what you are after?
I forgot to add the formulas.. so here they are



Reply With Quote
Reply

Tags
formula help, graphical indicators, ms project 2019

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Project - RAG status formula imzkhan4 Project 0 11-13-2018 12:25 PM
Graphical indicator formula for MS Project Graphical glitching in MS Word 365 seanspotatobusiness Drawing and Graphics 1 07-28-2018 02:55 PM
20 day gap indicator Planner18 Project 3 03-23-2017 04:09 PM
Graphical Indicators customisation Guloluseus Project 5 03-03-2014 06:06 PM
Graphical indicator formula for MS Project Implementing excel formula in project nawab35 Project 6 08-04-2011 05:45 AM

Other Forums: Access Forums

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