-
Date column formatting
Hi! In regional settings, I can change the default date format for a particular region. I'm not able to find anywhere to change the default manually other than creating another column with a formula. For example, I'd like to just have the date show month/day. Is there a place to do that? Thanks, Richard
-
Copy colour format from one sheet to another
Hi I want to copy the colour formatting of all the columns in one sheet to around 50 other sheet. Is there a way to do it? Currently I have to format each sheet individually. Paste Special is not working for me to copy the format. Thanks, Adarsh
-
HTTP/1.1 403 Forbidden
Team, I am using the Sample code provided with the SDK and it works on my desktop (Windows 10 - JDK 1.8.x). The same code deployed on my Linux server - JDK 1.8 fails with the following error What is the cause of this error when it works fine on my desktop? { request:{ command:'GET https://api.smartsheet.com/2.0/sheets', },…
-
JAVA API - Sight Update (save as new) method (RESOLVED)
Hello, I'm trying to update Dashboards using the JAVA API and in the documentation on-line, the Example Code says "todo"... Can someone please provide the correct usage of the updateSight() method. Thanks, T...
-
Dashboard and interaction help
Hi, i have created a workspace which has some reports and other sheets on, this is all rolled up into a dashboard. I have shared the workspace with colleagues, however when they click on a report it brings back a blank report with no data. Any advice please, i am sure i am doing something basic wrong. Appreciated as always…
-
Conditional formatting saving error
Im getting the attached error when i try to save conditional formatting
-
Chart Live Update
Hello, We are experiencing an issue with the chart functions within Smartsheet. We are currently using Smartsheet to collect and process help desk tickets. We have a form hosted on our intranet where users can submit help desk tickets. Those are collected and processed by our help desk team all in one sheet within…
-
Need to Resize Window Linked Through Dashboard
I have a shortcuts widget on my dashboard. This contains links to Smartsheet items as well as other useful links. When a user clicks on the link, the linked window appears but it cannot be resized. As an example, I have a link to a project sheet. The sheet comes up using a small portion of the screen, with the Windows…
-
Excluding Parent Row From Auto Populating System Data
Greetings, I'm trying to exclude my parent rows from auto populating my Status and all my Modified By and Created By data. Is this possible? I tried adding - into the fields that I could, and nothing happened.
-
Count number of days if status is "Open"
Hello, I'd like to count the number of days from created date to today only if the status of a ticket is "Open". If it's "Closed" I'd like it blank, I'm not sure how to do this. Here is an image of the ideal results Thanks!