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 '19 at 14:24
  • How do I add another tag to my question? – JamesE Aug 22 '19 at 14:34
  • There is an 'edit' button under your question - use this – Tally Aug 23 '19 at 7:40
  • Sorry for not responding sooner. Thanks for your help – JamesE Mar 13 '20 at 12:36

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 '20 at 12:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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