INDEX Function | Smartsheet Learning Center
https://help.smartsheet.com/function/indexReturns an item from a collection based on provided row and column indexes
Copying rows into another sheet, can you use automation to place a copied row into a specific row?
On "Tablet Input Test" when MAC address changes, I want MAC and Location to be copied over to row 001 of "Copy of Catalyst APs" instead of it being copied to the bottom of the sheet (there are 500 rows). Is that possible?
Best Answer
-
I would rather use INDEX/MATCH to populate the data into the second sheet based on the Number. Here the number will act as the unique identifier. Here's how the formula works
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/
Answers
-
I would rather use INDEX/MATCH to populate the data into the second sheet based on the Number. Here the number will act as the unique identifier. Here's how the formula works
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Amit, thank you very much. It works as it should!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I thought combining the four different sheets into one report would eliminate the need to share all four separately. However, I was just informed that they're unable to see the context of the report, …
- Hello, I created a smartsheet with a form, and when I saved this smartsheet as a new file so I could keep the template, I can't get the form to show on the left hand side of the screen for easy access…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
