Automation: Email with Set Frequency Until Cell Value Changes, Trigger Date Re: to Form Submit Date
I have a form being used as a ticketing solution for marketing requests. When users make a submission, one question is, "Have you provided all information?". Answer options are, "yes, begin with creative" or "no, more information will be entered later in Smartsheet".
So long as cell value is "no, more info will be entered later", I want an email to go out with x frequency (maybe every other day?) beginning the day (or so) after the submission is made, reminding them that creative doesn't begin until they change that cell value to "yes", and the reminder email does not stop until the cell value changes.
how can i accomplish this, please? all of the template automations don't seem to quite meet my need. i don't want to manually set up an automation every time i receive a request. TIA! :)