Next asset tag value formula
I'm using Smartsheet as an inventory management system which is working very well. Is there a formula that I can use in the sheet summary to search the values in a column to find the max value? This should give me the last asset tag number used. I am using =MAX([ASSET TAG]:[ASSET TAG]) but it's giving me a 0. We do have a prefix before the number. Could that be causing the issue? For example 1-ABC-00045.
Help Article Resources
Check out the Formula Handbook template!