Formula required for "current revision" column

Daniel Stewart · 02/20/20

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 · 02/20/20

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 · 02/20/20

Will it always be 2 digits?

Daniel Stewart · 02/20/20

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 · 02/20/20

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 · 02/20/20

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 · 02/20/20

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

Daniel Stewart · 02/20/20

thank you Paul, works perfectly.

Paul Newcome · 02/20/20

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.

Formula required for "current revision" column

Best Answer

Answers

Help Article Resources

Categories