How can I automatically populate a cell with the same info from another cell (SAME COLUMN /DIFF ROW)

Hello,

I have 1 sheet that I am creating and will continually add new rows of data to over time. There may be cases where an account number is listed more than once on multiple rows. If the account value was captured previously I want the account value number to autopopulate in the new row for that same account number. Ex: if I have an order from 3 months ago for the same account number I want the account value dollar amount to be entered as soon as I add the new order. What formula do I need to make the column? This is within the same sheet / different rows / same column.

Is this an index / match formula? Or something else? If you have an example of how to write the formula that would be great too because all I can find are examples from a 2nd sheet.

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    Is this a case where it would only be listed a second time, or would it be listed multiple times. In this instance I would add a couple of helper columns that have a SUMIFS formula. If you can provide a screenshot of the column names that you have, we could help you write a formula. If you want to go over it one on one - email me. michelle.choate@outlook.com

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!