-
Community Login is very random and troublesome
When I go from SmartSheet to the community to see great ideas, it always asks me to login to post comments or see details. So I hit Login, then it takes me to my smartsheet page that was open. Then when I go back to the community forum, it says to login. And on and on. With a few different clicks it finally seems to work,…
-
Tracking hours spent on a task
We need to track the actual time spent on each task (daily and/or weekly) in addition to the percentage completed (gantt) . Any ideas how I can configure that?
-
Card View - Card Layout
We use smartsheet as a CRM/Project management. Each Row is a new project we are quoting. In the rows we have over 25 different columns. The way we usually view and enter data in them is in card view. The problem is I would like to change the layout when viewing in card view, not just the order they are in, but actually…
-
New error on existing API code
This morning, I started receiving the following error message in c# code: Smartsheet.Api.InvalidRequestException: 'This feature is not available for your account.' on this line of code: CopyOrMoveRowResult resultsX = smartsheet.SheetResources.RowResources.MoveRowsToAnotherSheet(isheetX.Id.Value, directiveX, null, null);…
-
Summary rollup
Hello, I've never used Smartsheet and would appreciate your help. I'm working on a budget, we have 40 departments and each department needs to submit their budget. So I have 40 sheets and they are exactly the same, (same columns and same rows), the only difference is the data. What is the best way to add up all these 40…
-
Portal/Report that can update based on filter applied
Hi I am trying to create a report/portal whereby i can create a page that can show me information from 2 sheets. We have a recruitment process and I want to be able to show a page which has the following information: * Employee details (pulled from sheet A) * All the positions the person has applied for (pulled from sheet…
-
Automation the 2nd time a cell is changed?
In an attempt to reduce the amount of emails and notifications that my coworkers have to read, I'm trying to create an automation that only triggers starting from the 2nd time a cell is changed. I'm working with dates here and I'm looking for a way to basically ignore the cell change from blank to a date, and trigger an…
-
Wrong Date line
Hi guys, Struggling with what I assume is a easy fix. The dotted line that represents 'today' is showing to be out by 1 day. I.e, it is Tuesday here, however the dotted line is showing Monday. I have been into user settings and ensured that the Time Zone and Regional Preferences are correct however still cant get it to…
-
JIRA + SmartSheet connector error message - HTTP Client error
Hello, I've used the JIRA to SSheet connector several times to create SSheets without error. Today I received the following and my workflow was disabled. I have no idea how to troubleshoot this issue, any help appreciated! "An HTTP client error occurred while trying to connect to the Smartsheet API.". Do I hit the "reset"…
-
Can Approval Forms have addition fields/boxes for them to fill out?
Hi, Approvers were having trouble with adding links and tab names using just the comments box. many times they were looking for boxes to fill out. So I decided to add new fields to the approver's form as per attached but when the approve opens it, he cannot add any data into the fields (link, tab name etc) they are all…
