LookUp Results then Automate Resonse

jland47

Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo (PrimaryColumn field) and lookup to see if the value is stored in the sheet, if so then return a response contain 2-3 values in certain columns within that row/s. Hope this makes sense, I see maybe a dashboard might work but was hoping for something more automated.

kowal

hi jland47,

Seems like typical Index/Match formula you shall use in this case.

From what I get is that you want to provide Data (PO) into on Column and the rest of the columns shall fill themselves automatically based on a different sheet that also consist this PO?

https://www.youtube.com/watch?v=CJJwfvIYhM0

kowal

hi jland47,

Seems like typical Index/Match formula you shall use in this case.

From what I get is that you want to provide Data (PO) into on Column and the rest of the columns shall fill themselves automatically based on a different sheet that also consist this PO?

https://www.youtube.com/watch?v=CJJwfvIYhM0

jland47

Yes, that worked, pretty neat. I made a form to enter a po number and based on that po number, populate multiple columns on a sheet separate from the actual source data sheet.

kowal

@jland47 happy to help.