Hi!
I have a spreadsheet which I have created for my team of project managers to report finances of different programs.
So far it's work great, but I'd like to take it to the next level. I've made a summary table which currently looks at an activities stage in a project, the month the invoice has been raised, and the amount being charged.
This is great for seeing what has actually happened, but I would like it to also show what is planned. So I tried to write a formula that, should the 'Invoice Month' cell be blank, it looks at the 'Planned Delivery Month' cell. However, I'm still getting a zero returned to me. I have pasted my original and updated formula below, but I suspect they are too complicated.
Original
=SUMIFS(Main_Input[Gross Charge],Main_Input[Invoice Month],[@Month],Main_Input[CBS Phase],Activity_by_Value[[#Headers],[Connect]])
Updated
=SUMIFS(Main_Input[Gross Charge],IF(ISBLANK(Main_Input[Invoice Month]),Main_Input[Planned Delivery Month],Main_Input[Invoice Month]),[@Month],Main_Input[CBS Phase],Activity_by_Value[[#Headers],[Connect]])
I should point out as well that my Invoice Month cell has a formula in it which may be causing the problem...
=IF(ISBLANK([@[Date to be invoiced]])," ",TEXT([@[Date to be invoiced]],"mmm-yy"))
Please help!!!
Bookmarks