I have a blank sheet that i want to populate with only the column values from another that contain X
Hello
I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc
I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana, Crabapple
So i want my blank sheet to thanks to the function create new rows for each value in the new Apples column like:
Pineapple
Green apple
Red Apple
Crabapple
Ive tried VLOOKUP and Index, these work as long as i have a identifier.. but now im trying to get the identifyer in..
If and Ifthen functions i cant do so that they know to go down the list.. they only give me the first value..
Please help, but thank you if you do.
Answers
-
Have you looked into using a row report?
-
There are alot of differant lists that i only have read permissions to that i need to format into the same. Thats why im not only using report as unfortionatly there is too much variation and i have alot of filtering to do, where this is the last filter that i need to get fixed
-
Is this related to the other post I commented on?
-
Yes, all my posts relate to the same problem unfortionatly but a few differant ways of making formulas ive been trying to find a solution to
-
@Eric Sivacis Yeah, what I'd recommend is creating a row report from your sheet that only includes items that contain "apple" (or "Apple") and then creating a DataMesh that uses that row report as a source and your new sheet as a target and doing the "Copy and Add Data" option so it adds in any new records on the report that have "apple" in them to the target sheet.
Danielle W.
Product Marketing
Smartsheet
-
@Eric Sivacis Did you try the method I outlined in the other post?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives