The source data that I download to an excel file from the external system is in this format " 11/2/2020 10:59 AM". Smartsheet does not recognize this as a date when imported into a date cell. I am using the dates to chart year over year data. The only way I've been able to get it to work is to change the column to a text…
Given a column that uses a series of predefined dropdown values, is it possible to specify which of these may be selected from a Form or from a field within a Dynamic View? I don't want to present all options to users.
I want to integrate Smartsheet data to and from Azure Devops, both ways. What is the best way to do that?
I'm having connection issues with data uploader i.e. if I create a data uploader workflow, and grant access to Smartsheet to a Box or Onedrive folder today, the smartsheets seems to forget the access next day... it is not possible to manually edit the workflow everyday and fix the access issue for smartsheet everyday...…
Our two blueprints had dynamic report turned on until about two months ago when we turned it off when updating both blueprints. As I provision projects, some projects have an alert icon in the Control Center Project list with this message when you select the orange triangular icon even though they were provisioned long…
Hi! I'm new to the Calendar App. I was wondering if there is a way to show time blocks on the calendar. When I send to iCal to view in Outlook, everything shows up in the banner meaning everything is an all day event when it isn't. Not sure if this can be done or not but thought I'd ask. We are using the calendar app for…
I know it was announced at Engage that Hex Colors for Dashboards would be coming. When is this anticipated?
I have a project schedule sheet, within it i have parent/child rows outlining each workstream (parent) and associated tasks (Child rows). There may be up to 10 parent rows and up to 20 child rows per parent. I am looking to use the data uploader to bring in detail to the child rows, for the most part our resource planning…
Hi everyone, I had a premium Smartsheet account where i did many projects but during the last three months I stopped paying the fees. Now, I've been trying to activate the account and get the sheets but no way. any solution? thanks in advance
Hello, Wondering if anyone has a bit of experience with the Jira Connector for Smartsheets and might have run into this issue. I have created a bidirectional workflow to/from Jira and have run into an error on a field call "Line of Business". The error message is: Invalid response from JIRA. statusCode: 400, reasonPhrase:…
Hi, I am looking for the latest and greatest training information regarding how to sync your SmartSheet calendar with your outlook calendar. If anyone can help, please let me know. Thank you, Allison Bishop
Hello! I am new to Data Shuttle, I've gotten to flow perfectly once, and I decided to test it again and write down the steps and now I'm getting an error that says "Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns." However, all of my columns in…
Hi! Is there a way I could edit the Title of a calendar I created in Calendar App? I do not want to start over and create a new one just for the new title hence wanting to know if just the title could be edited. I am able to edit all other configuration through 'Settings' but just not the title. Am I missing something?
Help shape the future of Smartsheet. Share your ideas and feature requests.