Adding Case IDs to Smartsheet
I am trying to add a case ID for new rows that are being added to my sheet. I want the new row to be one number higher than the previous row (the smartsheet is set in reverse order, which is why auto-number is not working). I know I need to use IFBLANK and then add 1 to the row before, but I am not sure what the formula should look like.
Help Article Resources
Check out the Formula Handbook template!