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

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.


  • Travis
    Travis Employee

    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:




    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 ✭✭✭✭✭✭



    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




    But if the hours per days is 10, then

    4d = 4

    8h = 0.8



This discussion has been closed.