Nested MAX formula
Is there a way to use the MAX formula to look at a created column and check a box for the last entry of each day? I'm having no trouble getting the MAX to work for the full sheet, but it's not working for each day. I'm looking at the created date column and trying to return a checkbox from another column that is checked. I have tried several different options and cannot get it to work.
Answers
-
In looking at this I found the following note in the MAX reference description:
Usage Notes
- When referencing dates, you must use MAX in a Date column. See Column Types for more information on Date columns.
It appears that to get the MAX date you have to return that date in a column whose type is also Date. To do this you might want to add a summary column at the top of your sheet and run your MAX formula in the DATE column to show the MAX date in in the first cell. Then you could use the checkbox column to reference that cell and check the check box if the @row date matches the MAX date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!