Formula required for "current revision" column


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!