Hi guys,
I am trying to get my numbers column named ‘Overdue’ display how many days overdue an invoice might be based on the end date of the Timeline.
I would like it to only do that if Invoice status if ‘Payment Pending’
There may be a plug in or app that can do this, although I don’t think you can do this natively within monday without one! However, if you hover over that invoice due date section, it will tell you how many days it’s overdue!
You can also link the date with the Invoice Standing column to determine if something is actually overdue or completed
Hello there,
You won’t be able to calculate the days the invoice is overdue within a numbers column (with an automation).
However you can use this formula in a formula column to display the days the invoice is overdue:
IF({Invoice Standing} = “Payment Pending”, DAYS(TODAY(), {Invoice Due Date#End}), 0)
Unfortunately Formula columns are currently not supported in automations, so bear that in mind.