Link columes to another sheet, find end

Hey support,

I need your help. I have two sheets and I want to copy columes from one to another sheet.

The data in sheet 1 is updated automatically and the amount of rows varies. It varies from approx 1000 to 2000 rows.

In sheet 1 I added an automatic line ID.

In sheet 2 I created the line ID "manually" with a certain line (maximum).

With the formulas "=INDEX({Sheet1 Colume1}; MATCH(ZeilenID@row; {Sheet1 Bereich 1}))" I now copy the individual columns from sheet 1 to sheet 2. This also works.

My problem:

In sheet 1 there are only 6 rows. In sheet 2, however, data is displayed up to line 13, see picture.

Example:

In lines 7-13, the last entry from sheet 1 is always displayed.

My idea was to check the entry from colume1 is empty, but this doen´t work. It says "incorrect argument set"

=INDEX(IF(ISBLANK({Sheet1 Colume1}); "---"; {Sheet1 Colume1}); MATCH(ZeilenID@row; {Sheet1 Bereich 1}))

Do you have an idea how to solve the problem?


Regards

Christian

Answers

  • Amit Wadhwani
    Amit Wadhwani Community Champion

    Hi Christian

    Please try using the formula below

    =IFERROR(INDEX({Sheet1 Colume1}, MATCH(ZeilenID@row, {Sheet1 Bereich 1}, 0)), "")
    

    Best Regards
    Amit Wadhwani
    , Smartsheet Community Champion
    Smartsheet CoE, Ignatiuz, Inc., Exton, PA

    Did this answer help you? Show some love by marking this answer as "Insightful
    💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/

  • Hey Amit,

    thanks it works.

    I forgot the "0" in MATCH 😣.

    Regards

    Christian

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!