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

%3CLINGO-SUB%20id%3D%22lingo-sub-3008929%22%20slang%3D%22en-US%22%3ESharePoint%20List%2C%20If%20due%20(date%20column)%20data%20is%20greater%2C%20I%20want%20the%20progress%20(choice%20column)%20to%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3008929%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20some%20advice...%3C%2FP%3E%3CP%3ESharePoint%20List%20(Modern%20SP%20online%20365)%3C%2FP%3E%3CP%3EIf%20due%20(date%20column)%20data%20is%20greater%2C%20I%20want%20the%20progress%20(choice%20column)%20to%20update%20to%20'Overdue'.%3C%2FP%3E%3CP%3EAny%20solutions%20welcome.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3008929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3013340%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%2C%20If%20due%20(date%20column)%20data%20is%20greater%2C%20I%20want%20the%20progress%20(choice%20column)%20to%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801251%22%20target%3D%22_blank%22%3E%40Lee_GC%3C%2FA%3E%26nbsp%3Btake%20a%20look%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Senior Member

 

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.

 

1 Reply

@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