Send SMS reminder if form not submitted

[Yossi_Goldblatt]

I want to send an SMS reminder to staff to submit their lesson plans if they haven’t yet submitted it for that week. What formula can I use to look at the most recently submitted lesson plan for that teacher and if it was after a specific date then include/exclude from the sms reminder?

[kuovonne]

If you have two tables, one for teachers, and another for submitted lesson plans, you can get the latest date using a rollup field with the formula MAX(values). Then you can use another formula field to compare that date with some other date. Finally, filter on that last formula field.