In a project plan we have start date, finish date, and an estimated hours column to track against budgets.
I need to be able to identify and total projected hours needed by month.
Formula should return and absolute 36 hours for December - populating 20 and 16 in Dec column, 28 hours for January - populating 8 and 20 hours in Jan column, and some way identify a split for Task 3 hours across Dec/Jan (if that can't be done those tasks will have to be manually calculated - BUT ask for the moon and hope to land in the stars, right?)
I have created a test project plan and published with this link: https://app.smartsheet.com/b/publish?EQBCT=4f136586f0584577abff31ec15702037
Does anyone know how I would go about this? Any guidance would be GREATLY appreciated!