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
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!