I have a simple formula in my Google Spreadsheet calculating the start of the current week: =TODAY()-WEEKDAY(TODAY(),2) 1

It was working perfectly, but a few days ago it began returning a blank cell. All the dependent formulas also show up as blank. At the same time, I can see the correct formula result in the tooltip:

I have tried clearing cache and using other browsers, but it didn`t help. I also tried replacing the formula to calculate the start of the month (=EOMONTH(TODAY(),-1) 1) with no luck

Any idea how it can be fixed?

CodePudding user response：

I see a filter icon hiding to the left there. If you've got some filter active, it's possible that the results of these formulas are being shown at the bottom of the sheet, underneath blank rows.