This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Filter for date

Posted on 10-05-2020 08:05 AM
Anchor_Appadmin
New Member
Reply posted on --/--/---- --:-- AM

Hi,

i have a crated a app for daily transactions. in my google sheet i have data from 1/1/20 to till today. now i want to show the transactions monthly wise in appheet. can you please help me for that.

i have tried Group by date but its not working

0 2 137
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
hcquadros
New Member
Reply posted on --/--/---- --:-- AM

You can create a Virtual Collumn by month and group by it.

VC expression: TEXT([Date_collum],โ€œyyyy-mmmmโ€)

Posted on --/--/---- --:-- AM
Anchor_Appadmin
New Member
Reply posted on --/--/---- --:-- AM

thankyouuuuuuuuโ€ฆ

0 Likes
Top Labels in this Space