Hello, this worked great for me. How can I do the same for a monthly overview? Thanks
Use Month(Date) in a Math column. This will return a number between 1 and 12, where 1 is January and 12 is December. Then use similar if-then-else logic to that described in my original post.
2 Likes
Thank you so much!
I’m actually having a little bit of trouble with this. Can I have an example if possible? Thanks!
Show me where you are getting stuck.
The first column in the photo is the ‘Month(Date)’ formula. Now how can I use the if then else column to filter my timestamps by month? Thanks
Are you wanting to allow the user to select a month, and then filter by that month?
Not exactly. The users fill this form out and the timestamp populates when they submit it. I need to see how many forms were filled out in day, in a week, and in a month. So far I have the daily and weekly count. Now I just need to see how many forms were submitted this month.
ah, I see.
Okay, I would modify that math formula so that it takes the year into account as well. Use the following:
Year(Date)*10^2+Month(Date)
That will give you something like 202412.
Then create a second column exactly the same, except use the current DateTime (Now) as the input value.
Then your if-then-else column becomes:
- If Math Date equals Math Now, then
true
1 Like
This was exactly what I needed. Thank you, I appreciate the help!
1 Like