-
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…
-
Bring in data from multiple sheets
Hi, I'm fairly new to Smartsheet so apologies if this is obvious. I am essentially trying to bring information from 2 sheets which I can then edit or work on. Some background.. We have a sheet which details resourcing for ongoing projects (backlog) and another which contains information on the pipeline. The backlog gives…
-
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
