1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I have been attempting to make a project planner like a Gantt chart, But I wanted it to have levels to it, like 1. Project, 2. Tasks, 3. Subtasks. But I find it hard to implement. Any ideas

I have been developing a project manager for about a year... but I keep coming back to one problem.

I generally have 1 big sheet, But I am trying to have a drop-down section to include tasks and sub-tasks. I think it would be helpful to have the Project header to encompass the task information (% completed) As well, I can keep notes in the cells in the overall project and tasks. and I can back reference.

https://preview.redd.it/r21kraafgoqg1.png?width=1347&format=png&auto=webp&s=aff1662975fafed056168a2116af826b3fdefba4

I hope this makes sense on what I'm trying to achieve. Let me know if you have any ideas or if you think it's possible.... currently I have my Projects and tasks on two different sheets.

https://preview.redd.it/mr4oehtkgoqg1.png?width=379&format=png&auto=webp&s=2ca2b82da1cc615246976948495218127552c939

submitted by /u/Critical_While_4435
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#Excel compatibility
#google sheets
#big data performance
#Excel alternatives
#project
#tasks
#subtasks
#Gantt chart
#project manager
#drop-down section
#project planning
#% completed
#sheet
#notes
#task information