How to enter a formula referencing other cells within Duration?

edited 12/09/19 in Formulas and Functions


I have a column where I indicate the budgeted hours available for a task.  Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the duration cells.  Any idea why and how I would accomplish this?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!