Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Mathieu_De_gouv
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Mathieu_De_gouv - profile
Mathieu_De_gouv
4 - Data Explorer
since
Mar 04, 2021
Nov 29, 2022
User Statistics
3
Posts
0
Solutions
1
Kudos given
0
Kudos received
User Activity
Posts
Replies
Shorten SWITCH Formula
Mar 04, 2021
Is there any way to shorten this formula?
Re: Shorten SWITCH Formula
Mar 04, 2021
Kamille_Parks: SWITCH(INT(Month / 4), 0, ‘Q1’, 1, ‘Q2’, 2, ‘Q3’, 3, ‘Q4’) There some issues with the INT methods due to “roundness”… But I found happiness with CONCATENATE(‘Q’, DATETIME_FORMAT(Date, ‘Q’))
Re: Shorten SWITCH Formula
Mar 04, 2021
Awesome Kamille :fire: INT(Month / 4) is what I was looking for but DATETIME_FORMAT({Date field}, ‘Q’) is even better for me :winking_face: Thank U
Kudos given to
User
Count
Kamille_Parks
1
View all