Help to create the formula to take a row data from a sheet, and bring to the main sheet
I have a form that take users data. I need to compare a column data from this sheet with the main sheet and if match bring all row to the main sheet.
Answers
-
Use the Move a Row to Another Sheet workflow. Create the column formula that defines when the workflow should trigger. Something like this.
IF ([column1]@row = {column2}@row, "Match", "")
Then use the workflow with criteria when the cell is "Match", then the workflow will move the row to the sheet you define.
-
Hi Dojones, thank you by the answer, and sorry about my late. I'm trying something like the bellow, but is not working, I don't know why, do you or someone else see what I'm doing wrong?
=IF([Handover_DB]@row=1, VLOOKUP([PEP_DB]@row, {PEP / Project}1:{Customer Name}5, 15), 0)
Thank you in advance!
-
Dilson, your reference to the second sheet is incorrect.
{PEP / Project}1:{Customer Name}5
When you select the reference to another sheet it will give it a range name automatically. Something like below. You can rename to anything you like when setting the reference.
=IF([Handover_DB]@row = 1, VLOOKUP([PEP_DB]@row, {Main Sheet Lookup Range 1}, 15), 0)
-
Hi Dojones, thank you by the fast answer,
I was trying to reference the cell on another sheet in the formula just referencing the columns "{Customer name}" without use this resource to reference using the link to the cell in another sheet, because this kind of reference have a limit, right?
I'm not sure, but if I'm not wrong I did in the past the reference to a cell in another sheet just putting the column name betwin {} and the line number, is that possible?
-
Hi everyone,
Anyone knows if have some way to copy a cell from other sheet without use the reference link that is limited to (if I'm not wrong) 100 references?
Thanks in advance.
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!