I have a sheet that requires a stakeholder to complete a form when their name is added to a Reviewer column and a checkbox for "Reviewer Assigned" is checked.
I need a way to automate the resending of that form. Either a trigger via a new Resend check box to resend the form (but the automation would need to be viable to check+send multiple times), or a trigger based on blank columns tied to the form after tbd amount of days (i.e. if blank after 4 business days, resend form; if blank after 8 consecutive business days, resend form).
Can anyone help with this?