Vlookup from Created Date column

Clayton Ferreira

Hello,

I'm having trouble when I use vlookup from a column typed as "created date", every time a date is created after 6pm, my vlookup returns the following day, as shown in the screenshoot. Is there a way to fix this?

Darren Mullen

@Clayton Ferreira Smartsheet stores the Created date in UTC, even though it appears as your local time in the sheet. You can created a new column to ensure you are calculating on your local time. See my video here on how to do this:

https://youtu.be/S-GsCr9wA5g

Darren Mullen

@Clayton Ferreira Smartsheet stores the Created date in UTC, even though it appears as your local time in the sheet. You can created a new column to ensure you are calculating on your local time. See my video here on how to do this:

https://youtu.be/S-GsCr9wA5g

Clayton Ferreira

Thank you Darren, it worked!

Darren Mullen

@Clayton Ferreira Great! glad I could help :). It helps to have some videos I can pull out and share haha.