Automatic Duration column calculation + Linked Dates, is this possible?

Is it possible to have a "Duration" column that automatically calculates duration days based on End Dates that are linked to another sheet?

For context these are my 2 scenarios:

One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.

Two: My Start Dates are linked to another sheet, my End Dates are linked to another sheet, BUT now my Duration column stops automatically calculating my total days.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!