Max Date - Collect for the last entry
I am not even sure where to start today..
I want to collect the last date for the entry in the Solution #31 column. But this column should only have entries once per week (amongst 30 plus entries on the other items on the sheet).
Thanks!
Answers
-
Normally you can try something like:
=MAX(Date:Date) to pull whatever is the most recent date within that range but when you're saying you want to have entries once per week, could you expand upon that?
-
There will be entries throughout the week. But for that particular column, only ONE entry is required for the week.
There are entries every two hours (if the plant is running). So 12 line items per day x 5- but I just want to see the last time Solution 31 was verified by date.
-
I would recommend creating a helper date column (let's call it "Z") and run an automation which records a date in column "Z" whenever an entry is made into the Solution 31 column, then you can run the =MAX(Z:Z) formula which @kioshi43 suggested above (but change the "Z" column name to the name of your new automated date column).
Let me know if that works or if you need additional assistance!
-Jon
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!