What would be the Formula for Dates to How many Days calculation?

Options

What is the formula to tally these columns to automatically calculate how many days the each action takes to happen?

Submitted Date to First Worked on would be for Days to First Action

First Worked on date to Completed Date would be for Days to Complete

Submitted Date to Completed Date would be for Days Since Submitted


Answers

  • Malaina Hudson
    Malaina Hudson ✭✭✭✭✭
    Options

    @maynardg

    Calculations on dates are similar to calculations on numbers.

    Days to First Action

    =[Submitted Date]-[First Worked On]

    Days to Complete

    =[Complete Date]-[First Worked On]

    However - is it possible to complete something without working on it? This formula will throw an inaccurate result since there is no First Worked On date populated. If this is something you need to test for before measuring the date range, you may want to consider using an IF statement to test for the blank date before attempting the calculation.

    Days Since Submitted

    =[Completed Date]-[Submitted Date]

    However - on Days Since Submitted, if the product isn't complete, don't you still want to measure it to determine if something is lagging excessively in the work queue?


    Let me know how that works for you.

  • maynardg
    Options

    I think so, I will try it out.

    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!