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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!