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. Discussion List
Recurring Task Lists
Is it possible to set up a recurring task list so that when I check a task as "done" the due date automatically recalculates to the next due date? Ideally it would create a new task with the new due date that was not marked as done. Thx.
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…