Formulas For System Column
My sheet has a system column that shows the Modified Date of each row. Is there a way for me to pull the most recent date out to the sheet summary? I tried =MAX(Modified:Modified) but it says that it is an invalid column value.
Comments
-
Because its a system generated column you may need to break out the date into a user column first. You can use the DATEONLY function to separate out the date, then reference the max from that column. You'll want both columns to be date formatted columns.
-
Hi Mike! I tried that, but it still says INVALID COLUMN VALUE when I try to find the max of the DATEONLY column.
Nina
-
The error is indicative of trying to get a certain type of data (DATE) in a non-date column type. Whichever column the MAX formula is in, you need to make sure that one is set as a Date Column type.
-
Also make sure that your Sheet Summary filed is set to be a date type field.
Apparently my browser was taking a while to refresh. I see that Mike already got it.
