Formula Assistance

Formula Gurus - I need a formula that can be applied as a column formula in my column named Actual Duration (Days).

  • IF the row is a PARENT row, the formula should return the sum of its children rows.
  • For NON-PARENT rows, the formula should calculate the days between the Act. Start and Act. Finish columns.
  • IF there is an Act. Start but Act. Finish = NA, the formula should count the number of days between Act. Start and TODAY.
  • IF both Act. Start and Act. Finish, the formula should return 0.

Your help is much appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!