I am working on an issue tracking list inside SharePoint server 2013. And I have two columns as part of the list:-
- Review Status. with these choices; New, in-progress, Need Review.
- Review Date, of type Date only.
Now when an item is first created it will have its "Review Status" = "New", and its "Review Date" must be greater than current day.
now I am trying to implement this feature:- If "Review Date" is reached (“Review Date” = today), to automatically change the "Review Status" from “New” to “Need Review”?
Can anyone advice on the available approaches to achieve this ? is defining a workflow an approach to follow ?