-
Creating Master sheet
Dear All, I am currently looking at three different projects. I need to create a master sheet with the module, WBS and the Deliverables from each of these projects into one master project sheet. I tried the Report feature but it did not work. Can I please request you to send me some suggestions on how the same can be done.…
-
Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.
I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my totals. What are some best practices to display my column totals on a continuously…
-
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
-
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…
-
Lines disappearing from smart sheet
hello everyone, I’m wondering if anyone els is having this issue that I’ve been having for a while. My team and I have noticed that we are loosing lines of data without anyone from the team deleting it. I was scepticke at first when an employee told me that, but came to elizecthat it is true when it happened to me a few…
-
Chart data ranges
I am creating a dashboard with two separate charts. I want to compare the data between the two charts but the data ranges for each chart is different. One goes from 120 to 200 and the other goes from 100 to 500. Is there a way to set what the data ranges for the charts?
-
networkday trigger for update request -- requires opening sheet?
I have a number of update requests that I've set up to "trigger" from a column that calculates the number of networkdays left before a due date. For example, I want a manager to update the page count of a report 3 days before that report goes out to an editor so that we know if the length has increased. But, if that…
-
Track Task Delays
I want to track how long an open task is delayed on a project
-
Report connecting multiple sheets
I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status. How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.
-
Row sharing work around suggestions?
I am a new user of smart sheet. I have recently just set-up smartsheet as a tool to track around 200 customer work requests that are going through a University manufacturing workshop. The nature of the work means that there needs to be a reasonable amount of exchange of information between the technicians doing the…
