AppSheet works well with Smartsheet. For example, AppSheet automatically handles Smartsheet-specific column types like Harvey Ball and Color.

Use your Smartsheet account to sign into AppSheet. You can then build AppSheet apps using your Smartsheet Sheets or Row Reports.

If you are a Smartsheet business customer, the solutions team at Smartsheet can help with your AppSheet integration.

Creating an AppSheet Table based on a Smartsheet Sheet

You can add an AppSheet table which is based on a Smartsheet Sheet.

  1. In the AppSheet Editor go to the Data > Tables tab.

  2. Click the New Table button.

  3. In the Get data from dialog box, select "smartsheet".

  4. In the Choose a Sheet/Table dialog box, navigate to and select your Smartsheet Sheet.

  5. AppSheet will create a new table based on your Smartsheet Sheet.

An Appsheet table that is based upon a Smartsheet Sheet supports add, update and delete.

Creating an AppSheet Table based on a Smartsheet Row Report

You can add an AppSheet table which is based on a Smartsheet Row Report.

  1. In the AppSheet Editor go to the Data > Tables tab.

  2. Click the New Table button.

  3. In the Get data from dialog box, select "smartsheet".

  4. In the Choose a Sheet/Table dialog box, navigate to and select your Smartsheet Row Report.

  5. AppSheet will create a new table based on your Smartsheet Row Report.

An Appsheet table that is based upon a Smartsheet Row Report supports both update and delete. However, you cannot add new records to an Appsheet table that is based on a Smartsheet Row Report.

Using Smartsheet Dropdown (Multi Select) Columns

Smartsheet Dropdown (Multi Select) columns are supported by AppSheet but they require work by the AppSheet application creator.

If your Smartsheet worksheet contains a Dropdown (Multi Select) column and you wish to add or update that column's value using AppSheet, please do the following:

  1. Open the worksheet In Smartsheet.

  2. Click the dropdown icon just to the right of the Dropdown (Multi Select) column name, select "Edit Column Properties ...", and change the Column Type to "Text/Number".

  3. Open the AppSheet application in the Editor.

  4. Go to the Data > Columns tab and select the table containing the field corresponding to the Dropdown (Multi Select) column.

  5. Set the field's Type to "EnumList". In Type Details set the list of allowed values Values appropriately. In the Base type dropdown select "Text".

Doing this will ensure that AppSheet can add or update the column value in Smartsheet. This is necessary because when Smartsheet added the Dropdown (Multi Select) feature they did not update their API to fully support the new feature. When you update a Dropdown (Multi Select) field in AppSheet, we call the Smartsheet API to update the column in your Smartsheet worksheet. If the column in the Smartsheet worksheet is of type "Dropdown (Multi Select)" the Smartsheet API returns the error: Value is not supported for this column type. Use objectValue instead.

When you update the AppSheet EnumList field's value and Save your changes, AppSheet writes those values as a comma separated list into the corresponding Smartsheet Text column. When AppSheet reads the Smartsheet worksheet. it copies the comma separated list from the Smartsheet Text column into the appropriate dropdown values in the corresponding AppSheet EnumList field.

Using Smartsheet Dropdown (Single Select) Columns

Smartsheet Dropdown (Single Select) columns are fully supported by AppSheet.

When you add an new table to AppSheet which is based on a Smartsheet worksheet having Dropdown (Single Select) columns, AppSheet automatically creates a corresponding Enum type field in the AppSheet table, and populates that Enum field's Values property with the Values from your Smartsheet Dropdown (Single Select) column.

When you update the AppSheet Enum field's value and Save your changes, AppSheet writes that value into the corresponding Smartsheet Dropdown (Single Select) column. When AppSheet reads the Smartsheet worksheet. it copies the Smartsheet Dropdown (Single Select) column's value into the corresponding AppSheet Enum field.

Did this answer your question?