Sorting

Sarah Thompson

See below. Thanks for all your help, by the way!

Paul Newcome

And [Main Number] is a manually entered numeric value, or is that the one generated by a formula? Either way it is odd that it is sorting that way.

Sarah Thompson

It's the manual one. I agree, so odd! I can't figure it out.

Paul Newcome

Unfortunately I can't get it to duplicate. You may want to reach out to Support on this one...

(Edited to add link)

Sarah Thompson

Thanks, Paul!

Paul Newcome

Sorry we couldn't get it figured out for you. Please feel free to revisit this post with the results from Support. That way if anyone else is having the same problem, they can hopefully find a proper solution.

Sarah Thompson

Yes, will do. I submitted it today and have a ticket number.

Isaac Jose

Hello everyone,

Thanks for your post and discussion! I am currently working on Sarah's support case, and I'll do my best to let you all know the resolution. In the meantime, my best guess is that there may be a hidden time value associated with the date field that is throwing off the sort.

To visualize these hidden time values, enable dependencies on a project sheet then enter =Start@row+"" into a Text/Number column to see the Date+Time value. This also works with the Finish column.

By default, each 8hr work day starts at 8am and ends at 4:59pm with a 1hr break/lunch between 12:00 and 12:59. You can use elapsed time (e.g. Duration = e8hr above) to ignore the 8am-5pm restriction.

For Sarah's example, I suspect that the hidden time on Row 66 occurs after Row 65, causing 25108 to appear after 25111. The resolution would be to ensure that the formula in "Overall Trip Departure" uses the DATEONLY Function to convert the Date/Time value into a flat Date value.

Kind regards,

Isaac J

Smartsheet Support

Paul Newcome

@Isaac Jose Is this true with all dates? There is a "hidden" time value?

Sarah Thompson

That fixed the issue! Thank you!

I have the same question as Paul. Is this true with all dates?

Isaac Jose

@Paul Newcome @Sarah Thompson This is only true for the dates mapped in the project settings when dependencies are enabled. I'm glad that this helped!

Isaac Jose

To be explicit, I should add that while this is only true for date columns mapped in the project settings, another date column can contain a hidden time value if it is populated by a formula that references a date column mapped in the project settings.

Paul Newcome

@Isaac Jose Thanks for the clarification.