Lookup lists

You can edit the options for a data entry field.

When you group drawings in the data view by Discipline, the disciplines are displayed in the same order as the lookup list.

  1. Open the settings.
  2. In Account settings section of the menu, select Lookup lists.
  • In the lookup list settings, select the lookup list.

You can edit the options in a lookup list. The changes are saved automatically.

  1. Select Add new row.
  2. Enter the code, and then press the Tab key.
  3. Enter the name, and then select outside of the field.

    4. The name can have a maximum of 150 characters.

  1. Select the item.
  2. Edit the name, and then select outside of the field.
  • Select the Item, and then drag it to a different position in the list.

    • —Or—

    To sort the items alphanumerically, select Sort icon (Sort) on the toolbar.

You can export lookup lists to an Excel file where you can add new items to a lookup list, delete existing ones or re-order your list.

  • Rename lookup items in the web application rather than through the Excel import sheet so that they're also updated in any records that use them.
    1. In an RFI, you select High in the Importance field.
    2. In the lookup list settings, you change the lookup item name from High to Urgent.

      3. In the RFI, the lookup item is changed automatically to Urgent.

      Renamed lookup item
    3. You export the lookup lists to Excel and change the lookup item name from Urgent to Critical.
    4. You import the Excel file back into ProjectSight.

      5. In the lookup settings, the lookup item name is changed to Critical.

      In the RFI, the lookup item name is still Urgent. When you select the same lookup item for another RFI, the lookup item name is Critical.

      Renamed lookup item
  • The Excel file can only be imported into the account that it was exported from.

When you import the Excel file back into ProjectSight:

  • New lookup items are added.
  • Deleted lookup items are removed from lookup lists.
  • Reordered items are reflected in the lookup lists
  1. Open the lookup settings.
  2. On the navigation toolbar, select Project export toolbar button (Import/Export) > Export to Excel.

    3. The existing lookup lists are downloaded in an Excel file.

  3. Open the Excel file.
  4. On the Lookups tab, add new, delete existing, or reorder lookup items.
  5. Save the Excel file.
  6. In ProjectSight, open the lookup list settings.
  7. On the navigation toolbar, select Project export toolbar button (Import/Export) > Update from Excel.
  8. Select the Excel file to import.
  1. In the import error message, select Review Errors.

    2. The lookup lists with errors are exported to a new Excel file.

  2. Review the Feedback column and fix the associated errors.
  3. Save the Excel file.
  4. In ProjectSight, open the lookup list settings.
  5. On the navigation toolbar, select Project export toolbar button (Import/Export) > Update from Excel.
  6. Select the Excel file to import.

You can delete lookup items that are in use. A deleted lookup item remains linked to a record or item if it was previously selected, but you can't select the deleted lookup item for anything else.

  • Hover over the item, and then select Cancel icon (Remove).