Is the column type "Modified Date" a date column?
Hi, I'm trying to get the most recent date from a "modified date" column that smartsheet fills automatically.
Here is what I'm trying:
=MAX(Updated:Updated)
And I'm getting the error:
#INVALID COLUMN VALUE
Just for kicks, I changed the column type to a straight up "date" column and got the same error.
Help?
Best Answer
-
Hey @JLK
Did you change your formula column, [Days Pending], to a date column? Your Max formula will return a date, as @Anjanesh Vaidya's screenshot indicates.
Kelly
Answers
-
Hi JLK,
I have tried the same formula and it's working when the column type of the column where we are applying the formula is a 'Date'.
If it is still not working for you, can you please provide a screenshot for context?
Thank You !
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
The above is a screenshot showing that the column type is a date column.
and then this is my formula:
And this is the result:
When I add in brackets eg: =Max([Updated]:[Updated]), smartsheet autocorrects it to the above formula with no brackets.
Thanks for your help!
- Jennie
-
Hey @JLK
Did you change your formula column, [Days Pending], to a date column? Your Max formula will return a date, as @Anjanesh Vaidya's screenshot indicates.
Kelly
-
Kelly, Thank you so much! That solved it. Didn't realize that it also needed to be formatted as a date!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!