Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Get the value with the latest Date

Hi Experts,

I need help in getting the value from the item column of Test Sheet1 which has the latest date and put it in the test sheet 2.

I am trying to use, join(collect(Item sheet1 , Date, max(Date(@cell)) but not working.

Can you help me with the correct formula? And second question, what if I have 2 reference sheet (Sample Test sheet 3). How to adjust the formula?

image.png image.png

Thanks in advance.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions