Hi, I have a set of reminders in a row based on the assigned to and dates columns within the row. is there a way copy paste the reminders to the next row? or to all rows in the document?
Hi Matt
Provided you have the dates columns set up as a date column and the Assigned column too... then at the bottom of the sheet, Open Alerts /Reminders/ choose Assigned to rather than an individual, then the WHEN ie ON or 1 day before etc then choose the column with the key date.
NB Only people shared to the sheet will get the reminder, so make sure they are!
Regards
RichardR
Richard is correct! You can set a single sheet level reminder that will set a reminder for all tasks that currently exists and that are added to your sheet in the future.
I think I see what you are talking about but the wording seems to indicate that it would create the reminders for the sheet as a whole and not based on individual task dates. I am reluctant to create a rule that doesn't work or bombards everyone with every date on my sheet.
I will run a test before making live but it would be helpful if the wording was more descriptive to indicate that there will be a sepparate reminder created based on the specifics of each line. The description below leave a wide range of interpritations.