Sunday, January 3, 2016

yogi_For Every 2 Working Days Delay From Date Requested Enhance Priority Level By Numerically Reducing It By 1

Google Spreadsheet   Post  #2006
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-03-2016
post by: chale111111:!topic/docs/Q1NxSMHGAhE;context-place=mydiscussions
How to automatically update my priority level with each passing day?
I created a Request for Information (RFI) sheet which prioritizes from critical(0) to low priority (4). The question that I have is, if an RFI is sent to a subcontractor or the client as a low priority, but if they don't respond in a timely manner, the RFI is now becomes urgent, how can I have it update automatically in the spreadsheet without being a manual process? Is there a macro I can use or will I need to dust off my programming skills, or lack thereof?
For example, say an RFI is submitted to the client with a priority level of 2 and after 3 days of no response, it's going to impact the tight schedule and it should now escalate to level 3. How can I have it automatically up it to level 3 after 3 days without manually entering it myself? Hope that makes sense.