Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Multiple IF formulas in one field

Topic Labels: Formulas
Solved
Jump to Solution
390 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi

Currently, I have 3-columns

Snip20211111_17

  • 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

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.