Match statement
Hello everyone. I need some assistance again please.
I have an inventory ENTRY sheet which is a form that is populated by people out in the field confirming the Store they in and number of Products there.
This is populating multiple rows in the sheet as it should.
What I need is a CURRENT inventory sheet, that shows the store name and the quantity of products per row (there only 3 products they reporting on so having a column per product is fine).
I have got formulas in the ENTRY sheet (from links in this forum ) that looks up the store name and the most recent date and then ticks a checkbox. So I know what is the most up to date inventory record.
What I cant get right is looking up the rows with checkboxes and bringing that data into the CURRENT sheet.
I tried a report however when new data is submitted it moves the information down and the top rows are blank. So when looking at the report on the dashboard it looks blank until you scroll down to find the new info.
Any help would be greatly appreciated.
Thank you
Comments
-
Hi,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Managed to solve it with a helper column. Joined the tick box to the identifier column and then vlookup off that.
-
Great to hear that you solved it!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives