Excel To SmartSheet Formula Translation

Options
MayaHK
MayaHK ✭
in Formulas and Functions

Can we translate the following excel formula:

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

To Smartsheet?

· Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!