Hi,

We use spreadsheet sync to pull in our P&L each month by class (along with comparative periods). Each month we have to go to each class and update the date manually through the date picker. However, there is a formula option that allows you to select a cell or input a formula which I assume would allow us to have a dynamic date.

I have tried every combination of date or value format within the cell or within the formula. In no case will the Spreadsheet Sync except the date for the filter. The date picker shows a format that is yyyy-mm, but that doesn't work either. Has anyone gotten a dynamic formula for the date to work in the filters of spreadsheet sync?