Project Stages

Project Stages

From
Facebook
Status
Updating
Formulas
Share
ย 
๐Ÿ“…
This example uses a standard Date property but you'd simply use a Created Time property instead.

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", ""))))
ย 
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!