Autofill based on Previous value.
I am preparing a service request spreadsheet. Users will be entering the issues, and the service request number should automatically pop up. upon all of the values entered.
In this case, the Green highlighted values will be entered through customers via Form. Upon all of the values entered by customer, Smartsheet should be able to update new service request number, in a sequence with based on previous value. Example - Currently SR00001is maintained as number in 1st row. Upon user filling all of the details Smartsheet should generate new request number SR00002.
Help Article Resources
Check out the Formula Handbook template!