-
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.
-
Formatting With a Range of Dates
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
-
what is the best way to Integrate smartsheet into an Order based Manufacturing company ?
So i have been tasked with learning the In's and Out's of smartsheet and to find the best way to utilize all of its tools for our company. we currently do the majority of our work through GP which as an accounting program is great but doesnt have the best project managment capabilities. my Question is what would be the…