Hi

I’m creating a training tracker as a SharePoint list. Within the list I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Training + Refresher period.

If I set up a choice column with the following options – In Date, Expiring and Expired, how can I achieve the following:

When a refresher date is 30 days away the status changes to ‘Expiring’

When a refresher date has passed the status changes to ‘Expired’

Thanks

Darren

​Hi I’m creating a training tracker as a SharePoint list. Within the list I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Training + Refresher period.If I set up a choice column with the following options – In Date, Expiring and Expired, how can I achieve the following:When a refresher date is 30 days away the status changes to ‘Expiring’When a refresher date has passed the status changes to ‘Expired’ ThanksDarren  Read More

​