How to Calculate Dates Between Columns

Hello,

I am attempting to calculate days between two column dates

within Smartsheet. I used the NETWORKDAYS({column1},{column2}) formula and received the following error message #UNPARSEABLE

Screenshots have been attached for your review.

Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are the columns on the same sheet as the formula?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Beronica Muller
    Beronica Muller ✭✭✭✭

    No, they are not. I think that I have figured it out. I added a column to the smartsheet and used the following formula: =NETWORKDAY([Due Date]1, [Submitted Date]1) * -1. Is that correct?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need something on the source sheet to calculate the difference on each row. What you have should work for that.


    Then further calculations such as averaging or summing could be done on another sheet.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Beronica Muller
    Beronica Muller ✭✭✭✭

    Okay thank you. One more thing, I am trying to calculate the fields that are blank. I am getting an error message #UNPAESEABLE. I used the following formula:

    =IF(ISBLANK([Days (Due Date – Submit Date)]@row), "", IF([Days (Due Date – Submit Date)]@row <= 5, "Green", IF(AND([Days (Due Date - Submit Date)]@row > 5, [Days (Due Date – Submit Date)]@row >= 30), "Amber", "Red")))

    What am I doing wrong?