How can get the most recently register of FSE from table 1 and send the name of FSE to table 2
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
Best Answers
-
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)
-
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)
Answers
-
@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
-
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)
-
Thanks so much @Paul Newcome it Works
-
Happy to help. 👍️
-
@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:
-
Are the entries made in chronological order?
-
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
-
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)
-
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
-
Glad it is now working for you. Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!