FAQ
FAQ
You can use the Reminders feature to send notifications based on the dates entered in the sheet's fields. In addition to setting reminders for a specific date, you can also set them to be sent a certain number of days before or after the specified date.
If you want to send a reminder on a specific day of the week, such as a homework submission reminder every Sunday after class, follow these steps using a formula:
1. In addition to the "Class Date" field (A1), add a new date field as the "Reminder Reference Date" field.
2. Use the WEEKDAY formula in the "Reminder Reference Date" field to calculate the date of the next Sunday based on the "Class Date" field.
Formula: A1+8-WEEKDAY(A1)
3. Set this field as the "Reminder Reference" field.
The formula example above calculates the next Sunday. To specify a different weekday, please refer to the table below:
| Specified Day | Formula (A1 as the specified date) |
|---|---|
| Sunday | A1+8-WEEKDAY(A1) |
| Monday | A1+2-WEEKDAY(A1) |
| Tuesday | A1+3-WEEKDAY(A1) |
| Wednesday | A1+4-WEEKDAY(A1) |
| Thursday | A1+5-WEEKDAY(A1) |
| Friday | A1+6-WEEKDAY(A1) |
| Saturday | A1+7-WEEKDAY(A1) |
1. When the specified weekday is Saturday or Sunday, the returned date will be the next Saturday or Sunday after the Reference Date (A1), as shown in the example above
2. When the specified weekday is from Monday to Friday, the returned date will vary depending on the Reference Date (A1):
(1) If the Reference Date (A1) is a Sunday, the Reminder Date will be set to the following week's date.
For example, if the formula is set as A1+4-WEEKDAY(A1) to send a reminder on Wednesday, and A1's date is 2025/03/09 (Sunday), the Reminder Date will be set to 2025/03/12 (Wednesday), which is the following Wednesday.
(2) If the Reference Date (A1)) is any day other than Sunday, the reminder field will be set to the corresponding date within the same week.
For example, if the formula is set as A1+4-WEEKDAY(A1) to send a reminder on Wednesday, and A1's date is 2025/03/08 (Saturday), the Reminder Date will be set to 2025/03/05 (Wednesday), which is the Wednesday of the same week.
