Microsoft Project Formula to Smartsheet



I am using a formula in Microsoft Project to automate status changes based of date percent. I wanted to see if anyone would be able to decipher the MS Project folder to a Smartsheet formula.

IIf([Current Date]<[Start],"Early",IIf([Current Date]>[Finish] And [% Work Complete]<100,"Late",IIf([% Work Complete]=100,"Done",IIf((DateValue([Current Date])-DateValue([Start]))/(0.001+(DateValue([Finish])-DateValue([Start])))>[% Work Complete]/100+0.01,"Behind","On Track"))))

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!