-
Time Date Stamps
Hello new user here... Our company just went live with Smartsheet and we are working through typical implementation issues. One of our big surprises is that e-mailed discussions are not time/date/recipient stamped for reference. Did a search for this issue but suprissingly it didn't return a result. Have others found a…
-
Row Update Request recipient delete attachments?
We have built our Employee Annual Evaluation process into Smartsheet. While we have very tight access privleges on the Roster where the info is stored (HR personnel only), we are utilizing the "Update Requests" to the supervisor in charge of completing the evaluation. While Smartsheet manages the workflow/process, the…
-
Online Customer Order Forms for Customers and Sales Team
Hi, I signed up the free trial and have been watching a few of the smartsheet videos and playing around in the dashboard but I still am not clear if smartsheet will work for us and I'm hoping to share what I am looking for and then someone at smartsheet can tell me if will work for us or not. We are a small business that…
-
Can you schedule a report to run?
Hello, I just recently setup some sheets to help with payroll which tracks piece work (we're a manufacturing shop). They input the date they did the work and the number of pieces (I've built a sheet with every single part on it and put their respective price per part that calculates the total for that part). There is also…
-
Auto Date updating a published report of Events List
We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…
-
Update Requests: Search by recipient and unplanned reminders
I am using update requests quite a lot, but they are not for recurrent type activities. I would like to think they would be recieved and acted on, so I don't set up reminders. My problem is that recipients are working across many production jobs, and not reporting activity consistently, using the Update Request system.…
-
Copying excel worksheet cells to smart sheet gant chart cells
Hi, I have been asked to put my existing excel spreadsheet gant planning chart into smartsheet gant chart. Not happy as I am a total novice on smartsheet - but it is failry intuitive even for an old boy like me. I have figured out 'zooming' - it's not there.- not happy about that. So I am trying to copy a cell or set of…
-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.