Formula required for "current revision" column

Hello

I have a drawing register that i would like to add a current revision column that understand the relevant column and displays the latest drawings version added. The current drawings revision will need to take the last entry from "Issue 1 Revision" to "Issue 7 Revision" columns and copy into "

current revision"

here is a link to the sheet also.


Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Will it always be 2 digits?

    thinkspi.com

  • it will go up to 3 digits i have this drawings issue

    P1, P2, P3, P4, P5, C1, C2, C3, AB1, AB2, AB3

    i was hoping it would do a copy of a partciular cell.

    edit version of sheet


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Ok. The most straightforward approach would be a nested IF working backwards.

    =IF([Issue 7 - Revision]@row <> "", [Issue 7 - Revision]@row, IF([Issue 6 - Revision]@row <> "", [Issue 6 - Revision]@row, IF([Issue 5 - Revision]@row <> "", [Issue 5 - Revision]@row, IF([Issue 4 - Revision]@row <> "", [Issue 4 - Revision]@row, IF([Issue 3 - Revision]@row <> "", [Issue 3 - Revision]@row, IF([Issue 2 - Revision]@row <> "", [Issue 2 - Revision]@row, [Issue 1 - Revision]@row))))))

    thinkspi.com

  • hello Paul

    Thanks for this, not really good with the formulas but can it be copied and pasted into the current revision row as is.

    thanks Daniel

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 02/20/20

    You should be able to. Just double check that the column names themselves are correct.

    thinkspi.com

  • thank you Paul, works perfectly.