Wanting to create a summary sheet to show me "Today"

%3CLINGO-SUB%20id%3D%22lingo-sub-779679%22%20slang%3D%22en-US%22%3EWanting%20to%20create%20a%20summary%20sheet%20to%20show%20me%20%26amp%3Bquot%3BToday%26amp%3Bquot%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779679%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20existing%20Excel%20spreadsheet%20that%20I%20inherited%20from%20employees%20before%20me.%3C%2FP%3E%3CP%3EI%20use%20this%20to%20track%20employees%20in%20excel%20documenting%20their%20assignment%2C%20name%2C%20start%20date%2C%20and%20end%20date%20as%20my%20Column%20titles.%20I%20am%20trying%20to%20create%20a%20%22Summary%22%20sheet%20that%20will%20update%20daily%2C%20to%20automatically%20show%20me%20who%20is%20assigned%20to%20where%20for%20the%20current%20day%20(today).%20My%20aim%20is%20that%20so%20I%20can%20at%20any%20time%20open%20my%20spreadsheet%20and%20look%20at%20the%20summary%20sheet%20to%20see%20where%20everyone%20is%20%22today%22.%20I%20know%20it%20can%20be%20done...any%20tips%20to%20point%20me%20in%20the%20right%20direction%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780791%22%20slang%3D%22en-US%22%3ERe%3A%20Wanting%20to%20create%20a%20summary%20sheet%20to%20show%20me%20%26amp%3Bquot%3BToday%26amp%3Bquot%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384485%22%20target%3D%22_blank%22%3E%40Autobahn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20a%20high%20level%2C%20you%20might%20need%20to%20filter%20for%20all%20tasks%20where%20today()%20is%20between%20start%20and%20end%20date%20for%20the%20tasks%20(including%20those%20dates).%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20task%20list%20in%20the%20form%20of%20an%20Excel%20table%2C%20you%20can%20use%20the%20Data-%26gt%3BGet%20and%20Tranform%20data%26gt%3B%26nbsp%3B%20options%20to%20extract%20your%20summry%20view.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20this%20helps!!%20if%20you%20upload%20your%20excel%20sheet%20with%20realistic%20sample%20rows%2C%20someone%20here%20should%20be%20able%20to%20give%20you%20more%20specific%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 titles. I am trying to create a "Summary" sheet that will update daily, to automatically show me who is assigned to where for the current day (today). My aim is that so I can at any time open my spreadsheet and look at the summary sheet to see where everyone is "today". I know it can be done...any tips to point me in the right direction?

1 Reply
Highlighted

@Autobahn 

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.