How to create a Dynamic E-mail subject based on a date in Gallery Workflow on schedule

Question

Hi,

I am creating a very simple workflow for a month-to-date data to be sent to a customer on a weekly basis.

This workflow will be on Gallery and on schedule to run automatically every Monday and the last day of the month.

I already configured the email tool with the subject to be used for the weekly report, but I need the subject to specifically say "Final Report for MONTH" in the last report of the month.

Does anyone know how to do this dynamically if my workflow is on schedule?

Thank you!

FrederikE · Accepted Answer

Hey @grromerro,

If you change the tool order (first table then formula) you will get the field as a string type. The Mail tool willl be able to use this as the header. Doesn't work if it is a Report Type column.

grromerro · Accepted Answer

Thank you so much for your help and your time! It worked perfectly.