Send as an attachment PDF not refreshing



I have a spreadsheet with dates and lookup formulas that change everyday. I use the formula "=TODAY()" and "=TODAY()+1." Then I have a "COUNTIF" formula counting against those dates. The formulas in the spreadsheet itself work fine and update each day.

I have a report automation set up where I "send as an attachment," sending a PDF that is scheduled to send daily. The report is sending, however the PDF that is attached is old data and not refreshing for the new date. It worked just fine from 10/1-10/6, but starting 10/7, it stopped sending the updated report in the attachment. It's like it froze in time. I tried creating a new automation for it, but it's doing the same thing.

Any help would be greatly appreciated!