Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Soooooo Lost - Cant Figure Out A Formula

Hey Everyone, 


So glad I found this community!

I am currently trying to create a formula and am struggling severely with it! :(

I have multiple tasks that need to be performed. Task 1 may take X days, once its finished and only once its finished then Task 2 can begin and will take X amount of days and so on for multiple tasks. 

I cant seem to figure out how to create a (cascading?) formula that would take into account ONLY business days and produce a SUM for how long all the tasks combined would take as ONE project.

My apologies if this is confusing or extremely simple. I look forward to being pointed in any direction!


This discussion has been closed.