Update triggered by day of month, repeat daily until complete
Sending a single update request does not always generate a response because many people are not good about answering all their emails, and then it gets lost in old email. I'd like to generate a daily update request that begins on a set day each month (like the 14th) and repeats daily until the person completes the update request. So far my only solution is a manual reset of a trigger to generate a daily update request, but that's too complicated for this smartsheet because the update request needs to start on different days for different lines. Some need to start on the 20th, others on the 25th. Is there a formula I can use to change a status field based on the day of the month, then change it again after the update response? I thought I could do it with the TODAY and DAY functions, but TODAY only updates when the sheet is revised or saved. A dormant sheet would miss the trigger.