Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
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.
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
8h = 0.8
