Skip to main content
Solved

Multiple IF formulas in one field

  • November 11, 2021
  • 2 replies
  • 28 views
Tiaan_Terblanch
Forum|alt.badge.img+8

Hi

Currently, I have 3-columns

  • Due date (date field)
  • Overdue (formula)
    IF(IS_BEFORE({Due Date},TODAY()),“ :rotating_light: OVERDUE :rotating_light: ”,"")
  • Due Now (formula)
    IF(IS_SAME({Due Date},TODAY()),“ :gift: NOW :gift: ”,"")

I would love to see both results/formulas in the OVERDUE column. Then it is not necessary for both columns. That said, I am not finding the right way of merging these two formulas in one field/column.

Any help will be much appreciated.

Thank you

Best answer by Kamille_Parks11

IF() statements have three clauses: condition, value if true, value if false.

Your first formula’s value if false is "". Replace it with the entirety of your second formula.

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

IF() statements have three clauses: condition, value if true, value if false.

Your first formula’s value if false is "". Replace it with the entirety of your second formula.

Tiaan_Terblanch
Forum|alt.badge.img+8

IF() statements have three clauses: condition, value if true, value if false.

Your first formula’s value if false is "". Replace it with the entirety of your second formula.


Thank you so much; it worked.

Terms & ConditionsAccessibility statement