Feb 27, 2024
Trigger notification based on cell value that is static (not a date) compared to current date
TAs must refresh training every two (2) years. Based on the current date, is there a way to trigger a notification when say, it is 2023 Summer and two years have passed since a TA trained in 2021 Summer, so they need to refresh training?
This is what that column looks like: (I can't post the spreadsheet due to FERPA)
Yr/Sem
2022 W would need training 2024 W
2024 W would need training 2026 W
2022 F would need training 2024 F, etc.
2022 F
2023 F
etc.
I can add another column that will show the first day of a semester in date format, if that would help.
Example:
Yr/Sem Date
2022 W 1/4/2022
2023 S 5/4/2023
2023 F 8/4/2023
Is there any way to do this with a formula or something?
Note, if the solution is more difficult than a formula (macros, scripts, etc.), I need it explained in laymans terms please.
Details
Community content may not be verified or up-to-date. Learn more.
All Replies