Calculate total days between 2 columns

Annie Prescott

Hello! I searched high and low in the forum and couldn't quite find a solution to my issue. I have 2 columns "Entry Created" and "Resolve Date" that I would like to calculate the time between in Networkdays but here's the challenge:

- Both are auto populate fields (date and time inserted by smartsheet).

-I need to keep this formula as new rows are added to the sheet, but the "column formula" was not working for me.

Mark Cronk

Hi Annamarie,

Try:

=NETWORKDAYS(DATEONLY([entry created]@row), DATEONLY([resolve date]@row))

Do what you're looking for?

Mark

Mark Cronk

Hi Annamarie,

Try:

=NETWORKDAYS(DATEONLY([entry created]@row), DATEONLY([resolve date]@row))

Do what you're looking for?

Mark

Annie Prescott

Worked exactly as I needed it to! Thank you! So happy others are versed in the formulas for columns 😊

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the Community.

Mark