How can get the most recently register of FSE from table 1 and send the name of FSE to table 2

Jonathan Salinas

Mi situation is that need review int the table 1 who have the 280.1 and once i identify the most recently register need send the name of the FSE who has the 280.1 to table 2

Table 1

Table 2

This I need

Paul Newcome

You are going to need to insert a date type column and enter:

=MAX(COLLECT({Other Sheet Fecha Column}, {Other Sheet ID Kit Column}, [ID Kit]@row))

Then the formula you will want to pull the name is going to be:

=INDEX(COLLECT({Other Sheet FSE Column}, {Other Sheet Fecha Column}, [New Date Column]@row, {Other Sheet ID Kit Column}, [ID Kit]@row), 1)

Paul Newcome

Ok. In the source sheet we want to enter 2 new columns. A system generated auto-number column (no special formatting required) and a text/number column with the following column formula:

=MATCH([Auto-Number]@row, [Auto-Number]:[Auto-Number], 0)

Then we go back to the sheet you want to pull the data to and change that [New Date Column] to [Row To Pull] and switch it over to a text/number column. The new formula for this will be...

=MAX(COLLECT({Other Sheet New Text/Number Column}, {Other Sheet ID Kit Column}, [ID Kit]@row))

Then we would update the references in the formula used to pull the data to:

=INDEX(COLLECT({Other Sheet FSE Column}, {Other Sheet New Text/Number Column}, [Row To Pull]@row, {Other Sheet ID Kit Column}, [ID Kit]@row), 1)

Jonathan Salinas

@Paul Newcome could you help me please, I was tried so much time and feel me so tired, is so hard tried and don´t get the result

Paul Newcome

You are going to need to insert a date type column and enter:

=MAX(COLLECT({Other Sheet Fecha Column}, {Other Sheet ID Kit Column}, [ID Kit]@row))

Then the formula you will want to pull the name is going to be:

=INDEX(COLLECT({Other Sheet FSE Column}, {Other Sheet Fecha Column}, [New Date Column]@row, {Other Sheet ID Kit Column}, [ID Kit]@row), 1)

Jonathan Salinas

Thanks so much @Paul Newcome it Works

Paul Newcome

Happy to help. 👍️

Jonathan Salinas

@Paul Newcome I was testing the sheet and discovered another situation, when I have registers with the same date don´t take the las record, it take the first record look the images:

Paul Newcome

Are the entries made in chronological order?

Jonathan Salinas

The order are not changed it is by default, look the picture

the sheet control de kits is recorded by a form

and once the form is submited the register is registered in the sheet, look the image

and so on

Paul Newcome

Ok. In the source sheet we want to enter 2 new columns. A system generated auto-number column (no special formatting required) and a text/number column with the following column formula:

=MATCH([Auto-Number]@row, [Auto-Number]:[Auto-Number], 0)

Then we go back to the sheet you want to pull the data to and change that [New Date Column] to [Row To Pull] and switch it over to a text/number column. The new formula for this will be...

=MAX(COLLECT({Other Sheet New Text/Number Column}, {Other Sheet ID Kit Column}, [ID Kit]@row))

Then we would update the references in the formula used to pull the data to:

=INDEX(COLLECT({Other Sheet FSE Column}, {Other Sheet New Text/Number Column}, [Row To Pull]@row, {Other Sheet ID Kit Column}, [ID Kit]@row), 1)

Jonathan Salinas

Thank you so much Paul, I am new on smartsheet and tried with many forms and don´t get the result until reviewing the community on smartsheet and looking you are a master helping a lot of people in situations like me

Your answer help me and works, I mentioned the collumns like first, second and tird

Paul Newcome

Glad it is now working for you. Happy to help. 👍️