Smarter Formula Loader

Smarter Formula Loader

Enjoy the benefits of project dependencies AND calculate values in restricted columns

What is a Restricted column?

In a Project Sheet with dependencies enabled, Smartsheet stops you using formulas to calculate:

  • Start and End Date
  • Duration
  • % Complete
  • Predecessors

Smarter Formula Loader solves this:

  • Calculate the value needed in a hidden column
  • Send the calculated value to the restricted column without having to turn off dependencies to do it

Smarter Formula Loader:

  • Simple to manage
  • Configured within Smartsheet
  • Formulae are calculated within the same sheet

WHEN MIGHT I NEED THIS?

  • Calculating the Start Date of a project from a formula in another sheet
  • Adjusting Duration based on percentage allocation
  • Calculating % Complete from a status field or checkboxes, rather than using a manually updated column

WHO CONFIGURES & MAINTAINS THE APP?

SBP will help you set up the helper columns, the initial formulae and will program the initial formulae

All maintenance is controlled through your Formula Loader Admin sheet

FINAL THOUGHTS

  • Keep dependencies enabled but still set restricted columns as required
  • Price includes setup
  • Small annual renewal to keep the app functioning