Freelancer

Alert Formula

// If status is "Outlining" and payment not recieved, "🚨No writing until payment made" //
// If checkbox "Invoice Sent?" is ticked, "✈️ Waiting On Payment" //

if(empty(prop("Payment Recieved?")) and prop("Status") == "Outlining", "🚨No writing until payment made", if(prop("Payment Recieved?") or and(prop("Payment Recieved?"), prop("Invoice Sent?")), "✅ Paid", if(prop("Invoice Sent?"), "✈️ Waiting On Payment", "")))