Auto Number Formular
We find the Smartsheet numbering system not very good as if a value is inputted accidentally and removed it wrecks the auto number and find you have to change from auto number to text/number and repair the auto number and reconfigure it.
So I have been asked to create an auto number formular but with a catch. They one want the auto number to be added to a row. Once a failed check box is selected and this could located anywhere in the sheet ie row 10 then row 20 or row 50 etc.
I suspect this wouldn't be possible as Smartsheet cannot workout the last failed tick box and what auto number was assigned to that row for example QRN-001 in row 32 and the next fail could be in row 56 and would need to be QRN-002.
They have now decided to use a manual input rather than looking at a formular to achieve the results they are after.
I was wondering if anyone had come across this at all.
Help Article Resources
Check out the Formula Handbook template!