Hi I have a question about workflow. I am usi...

[Elijah_Magrane]

Hi I have a question about workflow. I am using a Timesheet app (based on the sample template) and I would like to generate a weekly summary of hours with different filters, ie., date, employee, job assignment. Is this only possible with the Report function or can I do this with a workflow rule?

[Aleksi_Alkio]

Yes you can use both

[Elijah_Magrane]

@Aleksi_Alkio what would an expression look like for a workflow rule that would be sent weekly? With only data from the last week? I have been trying to find examples but no luck.

[Aleksi_Alkio]

Something like… <<Start: ORDERBY(SELECT(Table[KeyColumn],AND(WEEKNUMBER([Date])=WEEKNUMBER(TODAY()-7),YEAR([Date])=YEAR(TODAY()-7))), [Date],FALSE)>> and possible other filters inside that AND expression.