Sheets Last Modified

oj6_projmgr

Hi,

I have a formula =MAX([Last Modified]:[Last Modified]) + "" for getting the most recent date in the Last Modified System Column to get the latest modification date is for the whole sheet.

Now, I'm trying to gather all those Dates and Times to get the most recent change in multiple sheets. However, upon linking them and using the same formula to compare multiple sheets, only the number 0 comes up.

Can you help me with my predicament.

Thanks.

Shaine Greenwood

Hello,

Your + "" at the end of the formula turns the gathered dates into text. That means you won't be able to use MAX to get the most recent date. 

My recommendation is taking the + "" out such that it returns a date value. You'll be able to use MAX in the same way.

Otherwise, you'll have to use a combination of the LEFT, FIND, and DATE functions to get the correct numbers and convert them back into date values. This leads to a complex and potentially problematic function that you'd have to create. LEFT and FIND can potentially get the correct numeric values for YY, MM, DD, then you can put those in a DATE function. This isn't the recommended approach, but if it's the only one to work for you, here's more info on these functions:

More on LEFT: https://help.smartsheet.com/function/left

More on FIND: https://help.smartsheet.com/function/find

More on DATE: https://help.smartsheet.com/function/date

oj6_projmgr

Changing the column type to Date and removing the + "" works but I lose the time portion that i get when + "" is present in the formula.

I need to have the time part on when the last update was.

J. Craig Williams

oj6,

Did you get a solution to your problem?

Craig