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     www.energyefficientbuild.com.   Jan-03-2016

post by: chale111111:

https://productforums.google.com/forum/#!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. 
----------------------------------------------------------------------------------------------------------------