Convert text date, to date 2018-04-18

I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field.

The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot find a formula to do that. Any help?

thanks d

Find more posts tagged with

Construction

Formulas

Support

=DATE(VALUE(LEFT(text,4)),VALUE(MID(text,6,2)),VALUE(RIGHT(text,2)))

Perfect...thank you sir.

@rjudenberg thank you, did not know the VALUE function existed!

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…