Home

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
Highlighted
Autobahn
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

@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. 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies