Skip to main content

Hi


Currently, I have 3-columns




  • Due date (date field)

  • Overdue (formula)

    IF(IS_BEFORE({Due Date},TODAY()),“ 🚨 OVERDUE 🚨 ”,"")

  • Due Now (formula)

    IF(IS_SAME({Due Date},TODAY()),“ 🎁 NOW 🎁 ”,"")


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

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.

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.

Reply


Terms & Conditions