Forum Discussion
Autobahn
Jul 30, 2019Copper Contributor
Wanting to create a summary sheet to show me "Today"
I have an existing Excel spreadsheet that I inherited from employees before me. I use this to track employees in excel documenting their assignment, name, start date, and end date as my Column title...
Kodipady
Jul 30, 2019Iron Contributor
At a high level, you might need to filter for all tasks where today() is between start and end date for the tasks (including those dates).
If your task list in the form of an Excel table, you can use the Data->Get and Tranform data> options to extract your summry view.
hope this helps!! if you upload your excel sheet with realistic sample rows, someone here should be able to give you more specific solution.