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.

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>