Excel To SmartSheet Formula Translation

Can we translate the following excel formula:

=INDEX(D:D,MATCH(MAX(IF(A:A=A2,D:D)),D:D,0),1)

To Smartsheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!