29 Jul 2019

Edit and delete columns in iSheets

Topics 2023-Q1-03
Product Filter HighQ Collaborate
Product Area Filter iSheets

After a column has been created it can be edited or deleted. Go to the Admin > iSheets page and click the More actions icon for the iSheet you wish to edit. From the drop-down menu, select Manage columns.

Search for a column

As of March 2023, if your iSheet has many columns, you can use the Search Column names and description field to quickly locate a column with either the name or description.

 

This page will display a list of all of the columns for that iSheet. From here you can click on the More actions icon for the column you wish to delete and then click Delete.

You will then be asked to confirm the deletion. Click Delete to complete the action.

The Edit Column page is identical to the Add Column page used initially for creating and configuring the column.  Nearly all column configuration settings can be changed, except for the Type of column.

You can change a Single line text column to a Multiple line text column, as there is no possibility of data loss or transformation. However, you cannot change a Multiple line text column to a Single line text column due to the character limit restriction and the possibility of data truncation. 

If there is a need to change the type of column after items have been added to an iSheet, first create an entirely new column with the correct column type. Then move the data from the old column into the new column. Depending on the type of data and number of rows, this can be done by manually re-entering the data, or by using the import process to copy the data into the Import template and for import into the iSheet in bulk. Only then, after the data has been copied and brought back into the iSheet should the old column be deleted.

More information on importing data can be found here

A lookup column source iSheet, once selected and saved, cannot be subsequently changed.

Was this article helpful?