Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2022, 12:41 AM
TristanMiles TristanMiles is offline Project Online - PWA RAG Indicator Windows 11 Project Online - PWA RAG Indicator Office 2021
Novice
Project Online - PWA RAG Indicator
 
Join Date: Jun 2022
Posts: 1
TristanMiles is on a distinguished road
Default Project Online - PWA RAG Indicator

Hi all, in need of some assistance
I am currently using project online linked with PowerBi and am trying to do a schedule RAG against set bassline for each project.
The formula im using is nearly there and working, however some tasks are showing green indicators with the text beside stating Amber or red.

Formula using is below


IIf([Finish] - [Baseline Finish] > 30, "Red", IIf([Finish] - [Baseline Finish] > 15, "Amber", "Green"))

I'm sure its a quick fix but i cant find it

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
upload/import local project into microsoft project online almb78 Project 0 02-07-2022 09:40 PM
Graphical indicator formula for MS Project Quinn87 Project 2 03-28-2021 11:38 PM
Can I do the following with MS Project Online? Nnemak Project 0 08-22-2017 06:22 AM
Comparison of Project 2013 and Project Online caz46 Project 0 06-01-2017 07:38 AM
Microsoft Project Server, Microsoft Project Online and Project Web App - Whats the difference? chocolateCupcakes Project 1 02-11-2017 12:25 PM

Other Forums: Access Forums

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