I want to Show only the current month data on the table
I tried adding =MONTH(TODAY()) but it didnโt work
How can i do this?
Solved! Go to Solution.
You need to create a Slice with below expression:
MONTH([DateColumnName]) = MONTH(TODAY())
Sorry I didnโt understand the meaning of Slice, Iโm new to appSheet.
I added your forumla and Iโm getting the following error.
The data then mixes with those from last year! How can I fix this?
If you are looking for data of current month in the current year, you could try
EOMONTH(TODAY())= EOMONTH([Date])
User | Count |
---|---|
43 | |
29 | |
25 | |
23 | |
13 |