Formula required for "current revision" column

Daniel Stewart

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.

https://publish.smartsheet.com/a07365f121a447e39c4a0dded5f0b252

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful. That way others searching for a similar solution can know that one may be found here.

Paul Newcome

Will it always be 2 digits?

Daniel Stewart

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

https://app.smartsheet.com/b/publish?EQBCT=78288a4ed2b7453eb388062785664d9c

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))))))

Daniel Stewart

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

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

Daniel Stewart

thank you Paul, works perfectly.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful. That way others searching for a similar solution can know that one may be found here.