Thread: [Solved] A Formula Request
View Single Post
 
Old 10-08-2015, 03:39 PM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
  
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default
In a text field:

switch([% Complete]=100,"blue",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=5,"red",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=10,"amber",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]>10,"green")
Reply With Quote