Find the number in a second sheet and search for the latest date


Hey community,

I have to sheets:

In sheet 1, I will show the latest date for a special "string". This date I need to search in sheet 2.

See picture below.

In sheet 1: For the number 43KA123456 it gives me back the latest date from sheet 2 for that number. If the number is not found, it gives me back "not found".

Sheet 1 has approx 10000 lines and sheet 2 approx 8000 lines.

I try it with =MAX(Collect()), but this doen´t work. But it could also have been a syntax problem.

Do you have an good idea how to handle this.

Kind regards


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!