Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Removing the "d" from the end of a numerical calculation

Options
Tonia Thomas
edited 12/09/19 in Archived 2016 Posts

Is it possible to remove the "d" from the auto calculated columns? For example I have an open date and close date and I want to know how many days it took to close that item.. when it auto calculates that item it adds a "d" at the end of the number. When I export the file to excel to review the data I have to manually remove the "d" so I can average that column.

Comments

  • Travis
    Travis Employee
    Options

    The duration column linked to dependencies will always show the duration type (w, d, h, m, or s).

     

    You have a couple options to strip the duration type out.

     

    First option is to insert a Text/Number column with a formula that references the corresponding Duration cell. This will display just the number.

     

    For example in row 5, add this formula to the new Text/Number column:

     

    =Duration5

     

    Update the cell reference to match the data in your sheet. 

     

    The other option is to use the NETWORKDAYS function to calculate the duration. Here's an example:

     

    =NETWORKDAYS([Start Date]6, [End Date]6)

     

    Both these options will display just the numeric value of the duration.  

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Tonia,

     

    Be aware that the duration value (=Duration5) will be in equivalent days.

     

    4d = 4.

     

    For each sheet, the work hours per days can be configured.

    By default, this is 8 hours. But it could be 6 or something else too.

     

    So that means for a typical sheet

    4d = 4

    8h = 1

     

    Craig

     

    But if the hours per days is 10, then

    4d = 4

    8h = 0.8

     

     

This discussion has been closed.