Delimit Date/time in a match/index function

Hi all,

I'm using a match/index function currently to pull over data from another sheet.

Currently I'm using this:

=IFERROR(INDEX({Google Sheets PTI Daily Form 6/19/23 Range 7}, MATCH(claimNum@row, {claim num}, 0)), "")

The sheet I'm referencing in the function has time and date in the same column, so the above formula pulls over data that looks like this: 2023-06-17T12:30:53-04:00

I'm hoping to only pull over the date, not the time. I suspect the MID function would be appropriate to add into my formula, but I've never actually used it. Asking for help to see if this possible? if so, how would I add that into my current formula.

Apologies if I'm missing any necessary context.

Thank you!


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!