Abstract: In some embodiments, techniques are provided for improving the detection of repeated actions during the manipulation of tabular data in order to enable the creation of automated action sequences. Activity log records are created that represent actions taken with respect to a set of tabular data. One or more normalized versions of the activity log records may be created. The activity log records (and, in some embodiments, the normalized versions of the activity log records) may be grouped and hashed together, such that groups of activity log records may be compared to each other by comparing the resulting hashes. Grouping and hashing may allow large numbers of comparisons to be made efficiently enough to support detection of repeated actions on large scale, multi-user, and multi-tenant systems.

Abstract: This disclosure relates to a method executed on a computer server in a data communication network. First, a source column identifier and a source spreadsheet identifier may be received from a source spreadsheet application. An extended column address comprising the source column identifier and source spreadsheet identifier may then be published. Next, the extended column address may be made selectable by at least one destination spreadsheet application over the data communication network. Then, a selection of the extended column address and a destination column identifier in a destination spreadsheet may be received from the at least one destination spreadsheet application. Finally, the destination column may be associated with the extended column address such that values of the source column are presented in a dropdown list for cells of the destination column in response to activation of cells of the destination column in the destination spreadsheet application.

Abstract: Systems and methods are provided for improving communication between a multi-user data service (such as Smartsheet) and a third-party data source (such as Salesforce). The multi-user data service requests object updates from the third-party data source via an application programming interface (API). A superconnector uses superuser credentials to check for updates to a given object via the API. If updates are found, then a plurality of user connectors use user credentials to retrieve the updates via the API. If no updates are found, then user connector queries are avoided. The avoidance of the user connector queries conserves bandwidth and processor time, and also reduces the likelihood of violating an API rate limit.

Abstract: Embodiments of the present disclosure present a calculated value within a card view presentation in order to overcome technical problems in presenting useful card view presentations on mobile computing devices. In some embodiments, the calculated value is a summary, analysis, or other type of information generated based on data associated with cards that are in a given lane. In some embodiments, further technical problems relating to the limitations of the interface of the mobile computing device in adjusting calculated view settings are addressed by presenting a simplified configuration interface. The simplified configuration interface presents a mobile-friendly view of limited configuration settings to allow the user to easily change settings relevant to the calculated value and/or the card view, and thereby adjust the card view despite the limitations of the interface of the mobile computing device.

Abstract: Systems and methods for providing a communication program interface that includes an integrated supplemental interface are provided. The supplemental interface provides access to data stored within a tabular data management system. The supplemental interface may present a form that is automatically generated based on a column layout in a sheet stored in the tabular data management system. The supplemental interface may automatically select a sheet to be opened based on information in a message, and may automatically add information from the message to the sheet. The tabular data management system may allow image data to be stored and displayed within cells of tabular data.

Abstract: In some embodiments, a card view interface of tabular data is provided that is suitable for presentation on small displays such as those found on mobile computing devices. Cards from a single lane are displayed, along with a set of lane indicators. In some embodiments, when a drag operation is detected on a card, a size of the set of lane indicators is increased in order to facilitate dropping of the card on an intended lane indicator, thus helping to overcome the technical limitations of small mobile computing device displays.

Abstract: Embodiments of the present disclosure present a calculated value within a card view presentation in order to overcome technical problems in presenting useful card view presentations on mobile computing devices. In some embodiments, the calculated value is a summary, analysis, or other type of information generated based on data associated with cards that are in a given lane. In some embodiments, further technical problems relating to the limitations of the interface of the mobile computing device in adjusting calculated view settings are addressed by presenting a simplified configuration interface. The simplified configuration interface presents a mobile-friendly view of limited configuration settings to allow the user to easily change settings relevant to the calculated value and/or the card view, and thereby adjust the card view despite the limitations of the interface of the mobile computing device.

Abstract: In some embodiments, a card view interface of tabular data is provided that is suitable for presentation on small displays such as those found on mobile computing devices. Cards from a single lane are displayed, along with a set of lane indicators. In some embodiments, when a drag operation is detected on a card, a size of the set of lane indicators is increased in order to facilitate dropping of the card on an intended lane indicator, thus helping to overcome the technical limitations of small mobile computing device displays.

Abstract: In some embodiments, techniques are provided for improving the detection of repeated actions during the manipulation of tabular data in order to enable the creation of automated action sequences. Activity log records are created that represent actions taken with respect to a set of tabular data. One or more normalized versions of the activity log records may be created. The activity log records (and, in some embodiments, the normalized versions of the activity log records) may be grouped and hashed together, such that groups of activity log records may be compared to each other by comparing the resulting hashes. Grouping and hashing may allow large numbers of comparisons to be made efficiently enough to support detection of repeated actions on large scale, multi-user, and multi-tenant systems.

Abstract: Systems and methods for providing an email client interface that includes an integrated supplemental interface are provided. The supplemental interface provides access to data stored within a tabular data management system. The supplemental interface may present a form that is automatically generated based on a column layout in a sheet stored in the tabular data management system. The supplemental interface may automatically select a sheet to be opened based on information in an email message, and may automatically add information from the email message to the sheet. The tabular data management system may allow image data to be stored and displayed within cells of tabular data.

Abstract: Systems and methods for providing a communication program interface that includes an integrated supplemental interface are provided. The supplemental interface provides access to data stored within a tabular data management system. The supplemental interface may present a form that is automatically generated based on a column layout in a sheet stored in the tabular data management system. The supplemental interface may automatically select a sheet to be opened based on information in a message, and may automatically add information from the message to the sheet. The tabular data management system may allow image data to be stored and displayed within cells of tabular data.

Abstract: Systems and methods for providing an email client interface that includes an integrated supplemental interface are provided. The supplemental interface provides access to data stored within a tabular data management system. The supplemental interface may present a form that is automatically generated based on a column layout in a sheet stored in the tabular data management system. The supplemental interface may automatically select a sheet to be opened based on information in an email message, and may automatically add information from the email message to the sheet. The tabular data management system may allow image data to be stored and displayed within cells of tabular data.

Abstract: Systems and methods are provided for improving communication between a multi-user data service (such as Smartsheet) and a third-party data source (such as Salesforce). The multi-user data service requests object updates from the third-party data source via an application programming interface (API). A superconnector uses superuser credentials to check for updates to a given object via the API. If updates are found, then a plurality of user connectors use user credentials to retrieve the updates via the API. If no updates are found, then user connector queries are avoided. The avoidance of the user connector queries conserves bandwidth and processor time, and also reduces the likelihood of violating an API rate limit.

Abstract: Systems and methods for managing a collaborative environment are provided. A plurality of sheets is stored in a collaboration system. The collaboration system tracks user interactions with the plurality of sheets and generates a collaboration graph based on the interactions. The collaboration graph is analyzed to determine similarities between the sheets and/or the users. One or more visualizations are generated based on the collaboration graph and the determined similarities. In some embodiments, the collaboration system is able to provide project management information even for dynamic workflows that are not explicitly defined.

Abstract: In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.