I am scheduling weekly covid tests and there are different testing schedules. I want to automatically scheduled the next test based on their schedule. So I mark a record that a test has been taken (check box), I want a formula to check their testing status (Monday, Wednesday, Friday), and automatically create a new record with the next test date. I can do certain days out, for weekly schedules, DATEADD({Test Date}, 7, ‘DAY’) but not sure how to make it day of the week specific.
I have a multiple select field that is dedicated to the days of the week they are testing, but I can change their field if there’s a field type that works better