Projects

<aside> 📅 This example uses a standard Date property but you'd simply use a Created Time property instead.

</aside>

Agreements by

dateAdd(prop("Created"), 14, "days")

Implement by

dateAdd(prop("Created"), 14, "days")

Invoice by

dateAdd(prop("Created"), 30, "days")

Report by

dateAdd(prop("Created"), 45, "days")

Stage

if(now() < prop("Agreements by"), "📝 Agreements", if(now() > prop("Agreements by") and now() < prop("Implement by"), "🛠 Implement", if(now() > prop("Implement by") and now() < prop("Invoice by"), "💰 Invoice", if(now() > prop("Invoice by") and now() < prop("Report by"), "📊 Report", ""))))

Stage (Combined)

if(now() < dateAdd(prop("Created"), 14, "days"), "📝 Agreements", if(now() > dateAdd(prop("Created"), 14, "days") and now() < dateAdd(prop("Created"), 20, "days"), "🛠 Implement", if(now() > dateAdd(prop("Created"), 20, "days") and now() < dateAdd(prop("Created"), 30, "days"), "💰 Invoice", if(now() > dateAdd(prop("Created"), 30, "days") and now() < dateAdd(prop("Created"), 45, "days"), "📊 Report", ""))))

<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>