-
How to link and sync status where multiple smartsheet rows need to link to a single Jira ticket?
I have a sheet with stakeholder requirements for a software development project. The rows are the individual requirements. Our engineering teams are working in Jira so their work items are Jira tickets. I need to be able to sync the Jira ticket statuses to the relevant line item in Smartsheet. The status sync works fine…
-
Automatically Sync Reports When a Source Sheet is Renamed
Feature Request: Automatically Sync Reports When a Source Sheet is Renamed in Smartsheet When a report is grouped or sorted by Sheet Name, renaming a source sheet doesn't immediately update the report. The new name only appears after a change is made and saved in the sheet. Until then, the report continues to display…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
IDEA: Auto-Populate New Users' Profile info from Outlook GAL or OKTA, OR Import info into contact
Please make it possible to Sync the Personal Settings>Profile details with an outside service, such as Outlook 365 Global Address List (Admin), OKTA, etc, so that the settings below are automatically populated. Since users will likely want to update the data or fill-in missing data, we'd only want it to pull the data into…