-
Showing percentages as whole numbers in Dynamic View
Hi, I have a Dynamic View of a sheet that uses percentages. They show up, however, with 13 decimal places even though they are whole numbers in the original sheet. How can I fix this issue and show the percentages as whole numbers in Dynamic View? The percentage is calculated in the original sheet using the formula…
-
Control Center Global Update - Add new column with multi -select dropdown
Hi, I'm unable to create a global update to add a new column with a multi - select dropdown . I tried also to add to to the template and chose add from existing and it gave me error "Error (1060) Column options are not allowed for Column type TEXT_NUMBER" -- This was not a text column it was a multi-select dropdown column…
-
Use Smartsheet as Site Survey App
Hello! I am wondering if anyone in the Community has customized Smartsheet and uses it as a form for collecting data during construction site surveys. After the questions, photos, and videos are collected through a form, I would like to be able to generate a custom report with all the details.
-
How to populate residential addresses on a form?
My team will be using a Smartsheet form to fill out applications which include basic info such as name, phone, address, etc. A major issue is getting everyone to fill out the address in the same format and spelling the addresses correctly. I had seen another company also using Smartsheet have a feature where you start…
-
Can I change the name of a workspace for projects created by Control Center?
Does Control Center link to the workspace name I enter or does it link to Smartsheet's workspace ID (for example: f9GQ4342rGWMqx2PHJ3Wq5Fqp72v74xX8)? If it links to the Smartsheet workspace ID, then it seems like I could change the workspace name and it won't cause any future issues with Global Updates. Is that true? Jeff
-
Jira Hierarchy not working for Epics & Features
Hi I have a Jira connection set-up and have checked on the option to include the issue hierarchy. The connection is working and has populated my smartsheet. The hierarchy is working between stories, spikes & tasks & sub-tasks. But it is not working between features & stories, nor between epics & features. Is this a…
-
Data Shuttle
Hello, I would like add a filter to import Data (Date) which is greater than a date. Is it possible?
-
Attaching Google Workspace files to rows
Why can't I attach a native Google Workspace file (Google Doc, Sheets, etc.) to a row in the Smartsheet Android app but I can in the browser version? In the app, it doesn't let me even select a Google Workspace file in Google Drive. I can attach pdfs and other file formats from Google Drive.
-
Jira Connector - Bidirectional sync not updating Jira when making changes in Smartsheet
I'm experiencing an issue where I make changes in Smartsheet and they are not being updated in Jira. The Sync is setup for bidirectional updates and I'm not receiving any errors in the connector. I only have 2 JIRA Filters set, no sheet filter and no Row Groups. It was working w/o issue up until the last couple of weeks.…
-
Updating an Existing Calendar with a New Sheet
Is there a way to sync information from a sheet onto an existing Google Calendar? as opposed to creating a new one? I know that it is possible to create a new Google Calendar from a Sheet, but the issue I have is that it provides a whole new Calendar, and what I want to do is simply use the Sheet to update an already…
