SharePoint List, If due (date column) data is greater, I want the progress (choice column) to update

[Lee_GC]

Looking for some advice...

SharePoint List (Modern SP online 365)

If due (date column) data is greater, I want the progress (choice column) to update to 'Overdue'.

Any solutions welcome.

Thank you.

[#2]

@Lee_GC take a look here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

However, if you need to store the value Overdue, you might want to consider customizing your form with PowerApps: https://blog.mydock365.com/how-to-customize-a-sharepoint-list-form-with-powerapps