Rankadv dates, or DATEVALUE

Hi,

I was trying to rankadv a series of dates (to calculate employee seniority), which isn't yet a feature. Since I cannot do that, I wanted to turn that date into a number that I could then rank, which in Excel I can do with the DATEVALUE function. Is it possible to get either of those in SmartSheets?

Sign in to vote!

Find more posts tagged with

Idea Submitted

Update Requests

ranks

dates

Comments

Paul Newcome

You can turn a date into a number with the YYYYMMDD format like so:

=VALUE(YEAR([Date Column]@row) + "" + RIGHT("0" + MONTH([Date Column]@row), 2) + RIGHT("0" + DAY([Date Column]@row), 2))

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…