0

I have a simple Query that groups my data by months that was working fine before, but now that I've introduced a formula into my date column, it's not working anymore. (I'm guessing it's because the majority data in the column is now formulas instead of actual dates).

=Query(C5:L,"SELECT SUM(I) pivot MONTH(C)+1",1)

Is there a way for me to still get my intended Query data without removing my formulas in the date column? (Query formula is in M2)

Thank you in advance!

Link to sheet: https://docs.google.com/spreadsheets/d/1EpvLMboKJ0KeR7tTqBarF1AnAg3jelhKTkyBhwKNlK4/edit#gid=1335125620

Beee
  • 49
  • 5

1 Answers1

2

Your formulas in Col C seem to be causing the issue since they're adding a blank space when there is no corresponding value in Col D:

=IF(D45=""," ",TIMESTAMP())

Instead, try:

=IF(D45="",,TIMESTAMP())

Aresvik
  • 4,484
  • 1
  • 5
  • 18
  • OH! That was such an easy fix! For some reason I thought having the formula there itself was messing with the Query. Thank you so much!! – Beee Aug 23 '21 at 08:51