Finally, we use the formula

[kexej28769@nongnue]

Working with the Month View tab (Planner and Stakeholder versions)

ماہ منظر میں چند اہم چیزیں چل رہی ہیں۔ tab . First, we are retrieving all the periods that we have اندر داخل ہواthe Task View .

Because the months don't always appear in switzerland number data correct format (i.e. subsequent filters don't work), we then use a =text() formula in the hidden column B to ensure the months stay as we need them.

Then, in the "Deliverables" section of this tab, we use the following formula:

=if(not(isblank(A12)), iferror(TRANSPOSE(FILTER('Task view'!B:B,RegExmatch('Task view'!A:A,B12))),""),"")
What we're doing above is checking if there's anything in the "month" cell of that row. If there is a month there, weIn Tasks view, we filter only the tasks that contain that month in the text month column. We then use the transpose() function to convert our filtered tasks from a vertical list to the horizontal list that we see in the sheet.

Finally, we use the formula below to filter the expenses listed in the Task View tab , in the same way we filtered the task names above. We then add all the expenses for the month together (plus the fixed monthly expenses) and subtract them from the total time/hours. This way we calculate how much we have left to play with, or if we are running out.