Recurring report recurrence updates and history tracker
 

Hi,
I have certain reports that recur every 9 days, 16 days, 22 days, 43
days and 76 days respectively. Some of these are workdays and some of
them are calendar days.
I have a weekly report tracker that lets me track which report is due
on a certain week. I want to automate it further. I am trying to do
the following
• Add a column for Status = DONE/Pending
• IF STATUS =DONE
THEN
{
Update the report recurrence to next day based on recurrence frequency
AND
Append the report name/instance to a named history sheet’s last empty
cell
}
ELSE
Keep it Active even if the week changes till STATUS = Done.

Thanks