Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

LookUp Results then Automate Resonse

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.

Best Answer

  • Overachievers Alumni
    Answer ✓

    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?

    Tomasz Kowalski

    Experienced IT PM and the Real Smartsheet Enthusiast.

    Is there anything else we can help you with? - book your time.

    MASA Consult - Your Aligned Smartsheet Gold Partner

    Find us on LinkedIn & Check our Smartsheet Solutions!

    Tag my name: @kowal if you want me to respond :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions