I have two date columns, "First Day of Travel" and "Last Day of Travel". Based on the last day of travel, I want to send a message to all users returning on that last day of travel a email reminder to fill out there Trip Report. I did go into edit column and try using Column Validation, but it did not work. Any help in completing this task would be greatly appreciated.

  • 1
    What you're suggesting can be achieved by using a workflow. If you try searching for other posts with the [workflow] tag, it should help with your research
    – Tally
    Aug 22, 2019 at 14:24
  • How do I add another tag to my question?
    – JamesE
    Aug 22, 2019 at 14:34
  • There is an 'edit' button under your question - use this
    – Tally
    Aug 23, 2019 at 7:40
  • Sorry for not responding sooner. Thanks for your help
    – JamesE
    Mar 13, 2020 at 12:36

1 Answer 1


You can use a SharePoint Designer workflow to achieve it.

Design it like the image below, you can customize the email body as your requirement:
enter image description here

For the Start Options, you can set: enter image description here

  • Thank you for your help!
    – JamesE
    Mar 13, 2020 at 12:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.