Changing my appsheet data from google sheets to smartsheet. How to include multiple tabs in

johnnipearson

Hello

I'm new to smartsheet and still learning how everything works.

I already have an appsheet app set up in google sheets but I want to change the data over to smartsheet, so everything is in one place.

I notice smartsheet doesn't have the ability to have multiple tabs? How do you transfer the multiple tabs over to smartsheet so I keep the structure and design on my original appsheet app.?

Does anybody know of an up to date youtube video about how to build complex appsheet app's in smartsheet for me to watch or any other handy youtube videos to get my appsheet app properly integrated into smartsheet?

Any help would be much appreciated!

Thank you, John

Genevieve P.

Hi @johnnipearson

Smartsheet sheets are individual (without tabs) - I would house multiple sheets in a Folder to group them together. You can use Workspaces and Folders to organize your data within Smartsheet.

Here are some Webinars and articles that you may find useful:

• Find your way around Smartsheet
• SmartStart Onboarding
• SmartStart: Sheets

Cheers,

Genevieve

Genevieve P.

Hi @johnnipearson

Smartsheet sheets are individual (without tabs) - I would house multiple sheets in a Folder to group them together. You can use Workspaces and Folders to organize your data within Smartsheet.

Here are some Webinars and articles that you may find useful:

• Find your way around Smartsheet
• SmartStart Onboarding
• SmartStart: Sheets

Cheers,

Genevieve

johnnipearson

Hi Genevieve

Thank you for the comment. I have saved the webinars and will watch them in due time.

I should have mentioned I have multiple tabs in google sheets which works in conjunction with Appsheet (app builder)

Do you have any good videos to watch about building appsheet app's in smartsheet that I may not be aware of? I have a suspicion I would need to connect multiple smartsheet sheets/tables together?

Any suggestions will always be welcome :)

Thank you and keep safe

John

Genevieve P.

Hi @johnnipearson

I would suggest importing each individual tab as a new sheet in the same folder. See: Import files to create new sheets.

Then yes, depending on how your current set-up is configured, you could link the sheets together either with Cross Sheet formulas or by using a Report! You can also build Dashboards in Smartsheet (see SmartStart: Dashboards) to gather data together, or if your plan has access to it you could build a Workapp.

Cheers,

Genevieve