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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!