-
Automating Update Requests
Having read many posts on the subject, I am guessing there isn't a good answer, but I figured I would try anyway: I am trying set up a recurring task list for process checks in our plant. Every day, each contact has a number of checks to do. I have figured out how to set everything up so that the update requests go out…
-
Automated backups of sheets using tool
So I'm using the Smartsheet backup tool on a linux server, it's very simply and looks great, you modify the properties file, run the jar and there's your backup. I'm trying to automate this backup using Crontab but it seems like the backup tool looks for the properties file from your current directory, obviously in…
-
Report showing resources and assigned projects
I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of…
-
Setting up a sheet for KPI's dates in row vs columns
I`m setting up dashboards which will be cascading with roll ups to the executive level. These are operations related data and not project related. In setting up the sheets I had looked at some of the templates and seen that very often they are set up with the dates of the entries running along the top of the sheet heading…
-
URGENT help on Master plan roll views
Dear All, A bit of a funny help but can anyone share the view of how their master plan gnatt chart. In my consolidated plan i inserted a column with a checkbox to see which rows should be presented in the gnatt chart. However my program manager wants to see the inter-dependency link too. and I was wondering if I am doing…
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Setting up a Notification to send to myself
Hi, I have an issue with Smartsheet and I'm not sure if I'm doing something wrong. I'm setting up a notification through the Alerts and Actions. I want to Smartsheet to send me a notification when one of my users updates a Row to tell me that an Order is being despatched. In the Delivery Settings, I have Shared user or…
-
Exactly Duplicating an existing SHEET to a new sheet
I have a sheet which records my orders as in attached. I want to make the NEW sheet with the exact same headings so I can remove the completed order from the Sheet #1 and move it to sheet #2 ( new) . Michael Ahmed michael@libertycards.com 817 937 5046 cell
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Admin Report - Sheet Tracker
Is there a report or query that can be done from the Admin account that shows all the sheets created in our cloud instance. I see that there is a total like 363 out of 500 sheets used, but it doesn't show date, who, sheet name and current status of that sheet (archived, deleted, new, etc). Is this possible?
