Report to Pull data from Current Month

Hello -

I use smart sheets to generate deposit logs for multiple clients. I give them access to their deposit logs via a dashboard. One of the reports they need is a deposit log for the current month.

At the moment, I just update the report criteria to return the current months by adjusting the dates the report pulls, but that's a very manual procedure that I'm 100% sure I'll overlook as the end of the month is a super busy time.

I'm sure there's a way to do this with some automatically...

Any ideas?

Andy

Find more posts tagged with

Reports

Comments

Andy_DAI

Ok -

So as soon as I posted, I had an idea:

A hidden column called "Current Month?" which has the following formula:

=if(MONTH(Date1)=MONTH(TODAY()), "A", "")

So only rows with the current month will have an A, then just set the report criteria to return rows with an "A" in the hidden column.

That works... but won't I have to open and save the parent sheet every day to get it to update?

Andy

Paul Newcome

If you are only looking for current month, you can get away with opening the sheet on the first day of each month to update the TODAY function. The month number isn't going to change on the second of the month or third or fourth, etc. So really you only need to open the sheet once at the beginning of each month.

There are a number of ways this can be updated without actually opening the sheet as well. All you have to do is ACTIVATE the sheet. If there is a cell link or cross sheet reference pointing at the sheet that changes something or an update request or form entry, all of these will activate the sheet and will update the TODAY() function.

Another option would be a third party tool such as Zapier where you can trigger an action to take place on the sheet on a recurring basis which will also activate the sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…