TermSheet is purpose-built to be flexible and allow teams to track the metrics that they find most important.
While new TermSheet accounts come with a list of default fields pre-populated, the platform is designed to be flexible and customizable, allowing customers to enter the custom fields to capture and report on critical data points.
Custom fields can be added to any objects in TermSheet including:
- Deals
- Contacts/Companies
- Properties
- Tasks
- Custom Objects
- Leases
- Loan Quotes
📑 Learn To:
🔒 Permissions:
Admin Role can access Fields in Settings by default.
Any user can add a custom field from the Deal Tab.
💡 Things to Consider
To protect the historical integrity of data in the account, custom fields cannot be deleted from TermSheet. However, duplicates or fields that are no longer in use can be hidden to remove them from view.
Hide fields by selecting the 👁️🗨️icon to toggle visibility or by editing the field and selecting the "Make field hidden" checkbox.
TermSheet does allow for calculated custom fields. Our customers have been most successful when they are managing their calculated fields in either the model or in TermSheet. (Not both!)
Customers who are using the TermSheet Add-in with Excel have found it most successful to keep calculations in Excel.
Only custom fields can be edited. Default TermSheet fields cannot be edited, but can be hidden as needed
Want to know if a field is custom or default to TermSheet? Check the "Created By" column on the list view! The name of the user who created the field will be listed if it is a custom field. If the field is default to TermSheet, the column will display "System"
Dropdown values in a Select Field cannot be edited once they have been created. They can only be added or removed.
⚙️ Steps
Add Custom Fields from Settings
-
Select the gear icon from the TermSheet header. This space is only accessible to those users who have been granted Admin Access.
-
Select Fields from the Settings menu. Then, select "+Add Custom Field".
-
Use the form to configure the custom field.
Object Type - (Required) Select where the custom field should display.
Label - (Required) Provide a name for the field. This will be the visible text in the platform to indicate what value should be added into the field.
Field Type - (Required) Select the type of data the field will collect.
Field Type options include:
Checkbox
Currency
Date
Decimal
Number
Percent
Related To (links the custom field to another record type)
Select (dropdown of options)
Text
Text Area
URL
Year
Dropdown Value - (Required when "Select" Field Type is used)
Field Description - (Optional) Provide additional context around what this field is intended to capture.
Default Value - Enter any value that should be applied to the field by default. The value can be overwritten manually if the field is not read-only.
Calc Code - (Required for fields calculated in TermSheet only) - Use basic code to build calculations in TermSheet. When setting up calculations in TermSheet, use the Field Name, not the Label.
TermSheet can assist with more advanced calc code in more complex scenarios. Contact support@termsheet.com for assistance.
-
Select "Save" to create the field.
Edit Custom Fields from Settings
Only custom fields can be edited. Default TermSheet fields cannot be edited, but can be hidden if needed.
-
Select the gear icon from the TermSheet header. This space is only accessible to those users who have been granted Admin Access.
-
Select Fields from the Settings menu.
-
Use the dropdown at the top of the page to navigate to different custom field lists
-
Select the pencil icon to update the field.
-
The Object Type & Field Type cannot be changed to protect the integrity of data in the account.
-
Custom fields cannot be deleted to protect the integrity of data in the account. To remove a field from view, select the "Make field hidden" checkbox.
-
To prevent users from adding data to the field, select the "Make field read-only" checkbox.
-
To enable a historical change log on the field, select the "Show audit log" checkbox
-
Select "Save" to apply the changes.
Add Custom Deal Fields from Deal Tab
Deal custom fields can be added to deals on the fly by any user.
Users who do not have Admin access will not be able to edit custom fields they create.
-
Select the Deal Tab, then select any view.
-
Select the👁️🗨️ icon next to the View Title.
-
In the search bar, enter the new custom field name. Since it does not yet exist, the option to add it will appear in the dropdown.
-
Add the Field Type and select "Add" to create the field.
