Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2015 Posts
Archives for July 2015
Discussion List
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?
Cell Linking and Circular References
I have created one parent sheet with multiple columns of information that I have copied into more limited child sheets. I've linked in all of the information in the child sheets from the parent sheet, so when the parent sheet is updated, the child sheets update with the related information. I do however want to give users…
Cell Linking to a Permanent Cell
How does one cell link to a specific cell, so i would always want a cell to read from Column 1 Row 1. If a new row is added I do not want the linked cell to drop down to Row 2.
Make a row dissapear from a sheet
Very basic question, I have a list of jobs in a Sheets. is it possible to make the row dissapear if I mark that row as done using a drop down list. I know longer need the row info in my sheets and I want to keep my sheets down to a managable size.
Net Promoter Score
I have a survey web form. One of the questions is "likelihood to recommend" with a dropdown list of 0 - 10. I'm trying to build a report from this web form that will automatically calculate the net promoter score (% promoters (9&10s) - % detractors (0-6s)). I know how to build the formulas to calculate these, but I don't…
Calendar view , extend tasks to show duration over multiple days
It would be great to be able to see the DURATION of tasks in Calendar view. At the moment you can just see the task start date! See attached example
adding numbers
hi when there is a sheet with , for example, 100 records...rows. and one of the columns is numeric, when I filter the column and sum the numbers the application add all the records not the filtered ones...
Item being migrated to a new Smartsheet server?
We are getting this error message on one particular smartsheet: Is anybody else having the same problem? Can somebody in Support contact me to resolve it? Its been going on for a few hours and is rather inconvenient!
real examples and projects
Hi, Are there real examples or projects that are built on smartsheet ? Thank you
Helpful Formulas for Larger Schedules
Here are a few formulas which are perhaps a bit more advanced, but have really helped our organization. I have also placed them into a published sheet found here, where you can see the formuals working. Weeks to Start Calculates the number of weeks away a task's start date is. This works for any date, such as a task's…