Schedule Delta %

peter_July22

Hi, I encounter "#Unpaseable" error code on the "Schedule Delta (%) formula with a number of attempts. Tried following the example shown in the Smartsheet's PMO template example as well as make slight change to correct a possible typo on Syntax in the Smartsheet example. See attached doc that captures the screenshots of the 3 scenarios - A), B) and C) on the formula - B) is Smartsheet's example that may have possible typo on the Syntax "Duration@row".

Please share your observation what could have gone wrong.

Smartsheet - Schedule Delta % Error.docx

regards,

PChuang

Naeem Ejaz

=IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")

Try this or share the file link.

peter_July22

Hi Naeem, I validated that have already set the Project Setting to what was suggested. Same error message "#Unpasaeable" persists. Are there any other possible bug somewhere that are unturned?

regards,

PChuang