![if statement - Auto serial number and text in Google Sheets: "Number - Text" by dragging - Stack Overflow if statement - Auto serial number and text in Google Sheets: "Number - Text" by dragging - Stack Overflow](https://i.stack.imgur.com/ZL8Mw.png)
if statement - Auto serial number and text in Google Sheets: "Number - Text" by dragging - Stack Overflow
![spreadsheet - Trying to auto-generate SKUs in Google Sheets using prefix and sequence number but it breaks when sheet is sorted - Stack Overflow spreadsheet - Trying to auto-generate SKUs in Google Sheets using prefix and sequence number but it breaks when sheet is sorted - Stack Overflow](https://i.stack.imgur.com/7bsCb.png)
spreadsheet - Trying to auto-generate SKUs in Google Sheets using prefix and sequence number but it breaks when sheet is sorted - Stack Overflow
![How do I serial number entries on two different Google spreadsheets in chronological order? - Stack Overflow How do I serial number entries on two different Google spreadsheets in chronological order? - Stack Overflow](https://i.stack.imgur.com/Wg7at.png)