If Text = multiple word choices, then write X

Platform discussions
1

Hi,
I’m trying to insert a formula based on a text column.
If the text column contains “January”, “February”, “March”, then insert “Q1”.
If the text column contains “April”, “May”, “June” = Q2
If the text column contains “July”, “August”, “September” = Q3
If the text column contains “october”, “November”, “december” = Q4

Can you help?

2

Hi Hayley,

Try:

CONCATENATE("Q",ROUNDUP(DIVIDE(MONTH(DATEVALUE(CONCATENATE({Starting Month}," 1, ",{Year}))),3),0))

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

Perfect! Thank you!