Microsoft app that tracks completion of reports

%3CLINGO-SUB%20id%3D%22lingo-sub-2978348%22%20slang%3D%22en-US%22%3EMicrosoft%20app%20that%20tracks%20completion%20of%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978348%22%20slang%3D%22en-US%22%3EHi%20all%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20give%20me%20guidance%20on%20a%20Microsoft%20365%20app%20I%20can%20use%20that%20can%20do%20the%20following%20task%20tracker%20that%20I%20currently%20have%20to%20use%20a%20excel%20and%20macros%20for%20please%3F%20The%20issue%20I%20have%20is%20that%20I%20have%20about%20100%20people%20accessing%20this%20excel%20sheet%20on%20my%20one%20drive%2C%20I%20have%20to%20manually%20give%20people%20access%20and%20I%20have%20to%20manually%20input%20new%20due%20dates%20periodically%3CBR%20%2F%3E%3CBR%20%2F%3EIdeally%2C%20I%20would%20like%20the%20app%20to%20do%20the%20following%3A%3CBR%20%2F%3E-%20generate%20a%20list%20of%20reports%20that%20need%20to%20be%20completed%20on%20a%20reoccurring%20basis%20indefinitely%20(due%20dates%20daily%2C%20weekly%2C%20monthly%2C%20bi%20annually)%3CBR%20%2F%3E-%20automation%20of%20new%20due%20dates%20for%20reports%3CBR%20%2F%3E-%20allocate%20to%20a%20specific%20team%2Fuser%20to%20make%20that%20report%20has%20been%20completed%3CBR%20%2F%3E-%20reporting%20on%20reports%20that%20haven%E2%80%99t%20been%20marked%20as%20completed%20by%20the%20due%20date%3CBR%20%2F%3E-%20storage%20of%20old%20data%20for%20auditing%20purposes%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2978348%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi all

Can anyone give me guidance on a Microsoft 365 app I can use that can do the following task tracker that I currently have to use a excel and macros for please? The issue I have is that I have about 100 people accessing this excel sheet on my one drive, I have to manually give people access and I have to manually input new due dates periodically

Ideally, I would like the app to do the following:
- generate a list of reports that need to be completed on a reoccurring basis indefinitely (due dates daily, weekly, monthly, bi annually)
- automation of new due dates for reports
- allocate to a specific team/user to make that report has been completed
- reporting on reports that haven’t been marked as completed by the due date
- storage of old data for auditing purposes

Thank you
0 Replies