Smartsheet does not allow multiple tabs per sheet like Excel and Google Sheets do. Though they are a spreadsheet their system has a lot more stuff happening on the backend.
One way to consider this is unfortunately, it’s not possible at the moment to have tabs in Smartsheet, but you can have them in the browser window instead and use multiple browser windows.
Once the sheets are imported to your account, you can use cell linking to link cells between sheets. Yes, multiple tabs for Smartsheets are essential – even if it is limited to 5-10 tabs. It is the one most annoying feature about Smartsheet that always makes me want to use Excel.
Only the first (left-most) worksheet tab of an Excel workbook will be imported. Look at the very bottom of your Excel workbook to see if you have multiple tabs.
What are capabilities that are not available in Smartsheet?
Capabilities that are not available in Smartsheet. These won’t be included in the imported sheet—for example, merged cells, multiple sheets in a workbook, or cell borders. Drop-down lists for data validation will need to be re-created in Smartsheet.
How do I create a new sheet in Smartsheet?
Look at the very bottom of your Excel workbook to see if you have multiple tabs. Import the workbook into Smartsheet once to create a new sheet, as described above. Go back to the Excel file and move a different tab into the left-most position by clicking on it and dragging it to the left.
Save the Excel file, and import it to Smartsheet again. This will create a new sheet based on the information in the tab you just moved into the left-most position.
To export any sheet or report from Smartsheet to Google Sheets, select File > Export > Export to Google Sheets. Similar to files exported in Excel, files exported to Google Sheets won’t appear exactly as it does in Smartsheet. Here’s a list of key differences:.