IF Statements Leveraging Formula Dates

Platform discussions
,
1

Without our board, we have a formula field deriving a particular date. We are trying to build another formula field that looks to evaluate which date, out of a series of dates, is closest to that date and mention it.

IF(FORMAT_DATE({CALC GA Date})<FORMAT_DATE(Date(2025,1,1)),“Pre-2025”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,12,11)),“v9.20.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,10,29)),“v9.19.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,9,18)),“v9.18.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,8,7)),“v9.17.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,6,26)),“v9.16.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,5,15)),“v9.15.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,4,3)),“v9.14.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,2,20)),“v9.13.0 TENT”,
IF(FORMAT_DATE({CALC GA Date})>FORMAT_DATE(Date(2025,1,19)),“v9.12.0 TENT”, “Post-2025”))))))))))

But I cannot seem to get it to work. Steps already taken to try to troubleshoot:

  • Reviewed multiple articles which had recommended the addition of FORMAT_DATE within the expression
  • Attempted to try to get a single line of the formula to work before looking at all the additional nexting
  • Try a slightly different equation of IF(FORMAT_DATE({CALC GA Date}) > FORMAT_DATE(TODAY()), “2025+”, “Pre2025”)
    Leveraging the last example - this was the kind of strange results was finding:
    image
    image560×356 20.3 KB

Not certain how to correct this.

2

Hi @jricco,

Try:

IF(FORMAT_DATE({CALC GA Date},"YYYYMMDD")<"20250101","Pre-2025",
    IF(FORMAT_DATE({CALC GA Date},"YYYYMMDD")>"20251211","v9.20.0 TENT",
    ...
    )
)

 

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.

1 Like
3

Thank you so much @GCavin - That did the trick.
Cannot thank you enough as I was banging my head on this one for way too long.