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 AND 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









