Ben SmithBen Smith
Ben Smith/
Bill Overdue
Bill Overdue
Bill Overdue

Bill Overdue

For
JohnBonThony
From
Reddit
Status
Updating
Formulas
if
if
>
>
now
now
Share
Bills

Overdue

if(prop("Paid"), "Paid", if(now() > prop("Due Date"), "Overdue", "Okay"))
if(prop("Paid"), "✅ Paid"
If Paid is checked display Paid, otherwise do the following if statement.
if(now() > prop("Due Date"), "Overdue", "Okay"))
If today's date is greater than Due Date display Overdue, otherwise display Okay.
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!