I'd like to join by date on these 2 sheets (Income
& Expense
), on key values month
and day
and add constant value from FixedCost
sheet,
Add FixedCost to every row/date:
Desired result, with subtotal on Dashboard
sheet:
Example sheet: https://docs.google.com/spreadsheets/d/1O1rZUstDNSXPdUVXvaDfPO4rAQs2cJWHimfGxbddtNU/edit#gid=1037187610
How can this be done? I've seen the array formula solution, but it looks like an inner join instead of a left join here: LEFT JOIN two and more tables in Google Sheets