Elapsed Time in Predecessors

We have a combination of production activities that go round the clock and people related activities that don't use weekends.

IN Microsoft Project, I am either to get around this issue by either setting a 7 day a week calendar OR using elapsed times in durations and as values for lags in Predecessor.

In smart sheets, I am able to use a 7 day a week calendar (which works for me) but does not work for the Rolled up calendar I am trying to link to. THey use a 5 day calendar and this throw all the values off.

I am able use elapsed time e5d in duration but I am not able to use the same value in predeccesor 5FS+e5d. Smart sheets seems unable to use elapsed time in the predecessor column.

ANy suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!