Help Creating Smartsheet formula
I need a smartsheet formula that will compare rows that have the can detect when two rows have the same "Serial Number" (Serial Number column) and extract/identify the one with the latest "Date" (Calibration Date column)
We were able to use the following formula to identify which rows have the same/duplicate Serial Numbers
=IF(COUNTIF([Serial Number]:[Serial Number], [Serial Number]@row) > 1, 1, 0)
The following formula was used in excel and worked:
=INDEX(D:D,MATCH(MAX(IF(A:A=A2,D:D)),D:D,0),1)
Where D is Date and A is the Serial Number
Please help :(
Answers
-
Try a MAX/COLLECT combo instead of the MAX/IF.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!