Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 25, 2021 01:46 PM
I’m sure I’m missing something simple here, but I’m trying to make formula that outputs the correct Quarter and then Year based on a relevant date field. So like Q1 - 2020
What I’ve come up with so far isn’t working, possibly because I’m missing something or have been a bit too confused by the nested IFs
IF(OR(Month({Date Start})=1, Month({Date Start})=2, Month({Date Start})=3), “Q1”,
IF(OR(Month({Date Start})=4, Month({Date Start})=5, Month({Date Start})=6), “Q2”,
IF(OR(Month({Date Start})=7, Month({Date Start})=8, Month({Date Start})=9), “Q3”,
IF(OR(Month({Date Start})=10, Month({Date Start})=11, Month({Date Start})=12), “Q4”," "))))
&
" - "
&
Year({Date Start})
Any guidance is appreciated!
Jan 25, 2021 04:29 PM
Figured this one out:
IF({Date Start}=BLANK(),"",DATETIME_FORMAT({Date Start},‘Q’)&"Q | "&YEAR({Date Start}))
Did not realize the DATETIME_FORMAT formula had a quarterly output option!