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