Two new PPM Functions: Successors and isCritical, available now!


Hi Community, 

We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical

The Successors function (type: numeric) allows users to calculate the direct successors of a task and return a collection of values that will occur as a result of the referenced task. Successors are the direct tasks with a dependency after the date-driven event for that particular task has occurred - in other words, the task(s) that can begin after one finishes.

The isCritical function (type: logic) allows users to determine whether the row they are currently working on is on the critical path; whether or not the task is going to affect the final end date for the entire project. This formula, commonly used with the IF function, will return one value when true, and another when false.

These two new formula functions will help project, program, and portfolio managers more effectively plan out, report on, and quickly mitigate risk in large-scale, dependency enabled project sheets. If you have feedback or suggestions on how we can improve the formula experience in Smartsheet, please fill out an Enhancement Request for our product team to review. 

You can also stay informed by Subscribe to receive release notes for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a daily email with news of what's released. (Emails will be sent daily, Monday-Friday, as new releases are available).





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!