calculating number of days

Options

Need help trying to calculate number of days for my project so it will auto-update each time a row is added

The idea is to calculate the difference in days between, in this example Date row 2 and row 1 in a different column (days). I was able to get it to work utilizing =NETDAYS(Date2,Date@row) formula however when I try to convert to a column formula it returns a syntax error because, I believe I am looking up a specific cell. I need this to work in a column formula to allow subsequent updates to auto calculate difference in days. Any help would be appreciated.

Answers

  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭✭
    Options

    Are you using a duration column in your sheet?

    Ken Armstrong

    Smartsheet Operations Analyst, Carelon Medical Benefits Management

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

  • Nick Caputo
    Options

    Ken,

    Sorry for the delay in responding

    No I am not utilizing duration because in this instance the goal is to calculate the difference between dates in subsequent rows. More specifically. the idea is to utilize a form to track the duration of when a fleet vehicle is placed out of service and , ideally reflect on a dashboard the duration that is took to get it back in service

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!