Calculating completion date from multiple turn around time and date assigned

Lyn C

Hi All,

I have created a workload management sheet. Within the sheet 1 column is for Turn Around Times (there are multiple) and 1 column is for Date Assigned. I need to calculate the Completion Date from the Turn Around Time and Date Assigned: Date Assigned + Turn around Time = X.

What is the best formula to use?

Thank you,

Lyn

Dakota Haeffner

Hey Lyn,

I was looking at doing something similar a while back and this page helped me.

Hope it helps!

How to Add Days to a Date in Smartsheet (alphr.com)

Lyn C

Hi Dakota,

This issue is the turnaround time is multiple values, it could be any number between 1 and 15. The calculations should be 'Date assigned + TAT = Completion date'. The sum formula doesn't work correctly, should I use a date formula?

Thank you,

Lyn