I’m trying to figure out how to create automatic reminder emails based on 2 concurrent factors: a dropdown list and a date.
I don’t know how to insert a code, but I can put in a screenshot (below). Essentially, I have a list of todos, and some of them are follow ups. I have so many that I need them emailed to me as a sort of (mental) filter. I want the item emailed to me if the row meets 2 criteria: status=scheduled and date=today. How do I do that? Seems like it’d be simple but I just can’t get it to work. Below is the formula I’m using . . .