I have developed a continuous improvement register and I am trying to adopt a priority rating (drop down box) where on selection an automatic date is entered in the next column. Must Do (90 days from today's date), Important to Do (180 days from todays date) and Action Required (12 months from today's date). I can't seem to get this to work.
In the register I do have the traffic light system working against the due date so I need that to continue to work. The register also has a an automatic reminder system attached which is working fine still.
If anyone can help me that would be great I am at my knowledge point!
Bookmarks