-
Facilities Maintenance Plan
Hi, Does anyone use SS for their facilities maintenance planning and tracking? If so, I would be interested in touching base. We are putting together a multi-year facilities maintenance program in SS and any help would be appreciated. Thank you, Archie Lopez
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
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…
