-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Smartsheet Workspace to excel using the connector
Before upgrading to the next tier (where the connector exists), I want to make sure what I want to do is possible. Can the connector pass an entire workspace to Excel, rather than individual files. There is a workspace that contains many gantt chart files and an easy to view row summary of each chart is wanted such that it…
-
Not a Lisenced Administrator
Hi there I have only tree Lisenced Administrator on my company. I wanted to know... if the other people at the office can be sheet owners for what lap of time? Is there a time limit for them to be sheet owners? Because one of us was been sheet owner but the other day he couldn't do no more. Does smart sheet has some kind…
-
One form for multiple sheets
Is it possible to use one Form to fill-in fields in different sheets depending on the option selected. For example, if a user selects Sheet1 then data would be populated in Sheet1, and when user selects Sheet2 data would be populated in Sheet2. All sheets would have the same layout and same required data to be filled-in, I…
-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
Help Desk Ticketing templates
I am working on leveraging the Help Desk template to manage our customers' IT tickets. Requirements: 1. I need for the submitters to receive an auto acknowledgement of their service requests. 2. I need for the technician to be able to communicate back and forth with the submitter via the ticket. This will allow the…
-
Using Forms as a Checklist
Hi I have a list of 96 items which need to be checked off as a QA task. I have the 96 items in the Primary Column and I have 8 further columns, four checkboxes for "Compliant", "Non-compliant", "Unable to Check" and "Not Required", one plain text column for "Comments", one contact list for "Next Action For" a text column…
-
Schedule Form Deactivation?
I'm doing trivia through SmartSheet forms. Everyone who is participating has until Friday at 11am to submit their answer. I know I can physically go into the form and deactivate it. Is there a way to schedule the form to deactivate at a certain date/time?
-
Change Google Drive Account
I've been experimenting with Google Drive to share docs on a Sight. I now need to associate a different Google account vs the original I used to test things. I am unclear how to do that. Can someone share how to make that change? Thanks.
