Formulas For System Column
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives