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
how to connect smarsheet with Oracle Database
Need some ideas around connecting the Smartsheet to import data from a database based on a parameter.
Want sum calculation in report - Formulas in reports?
Does anyone know if there is a way to add a formula for a report? What I want to do is sum the values of a column for all rows returned for a report and to add some sort of highlight when the sum exceed a certain value. Specifically, if the amount of hours for a list of tasks for day assigned to a given person exceeds…
Check if Child Row
We use the formula =IF(COUNT(CHILDREN()) > 0, 1, 0) to check a box if a row is a parent row. This is a helpful tool when using conditional formatting to format rows which are parents, automatically. We'd like to do a similar thing if a row is a child row, but I cannot think of a way to do perform this logic. Has anyone…
Workhours per Resource
Hi! Is there a way to set workhours for a particular resource (say the resource can only work on projects for 4 hours a day)? Thanks!
COUNTIF with Dates
I am trying to use COUNTIF referencing two Dates columns. The first "Due Date" column has dependencies. The second "Dates" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called "Total Due" that counts how many tasks…
Editing a template
How can I edit a template to delete a row?
Can you automatically apply a format to parent rows?
I would like parents rows to be formatted bold automatically in my sheet. I looked into conditional formatting but it did not have an option to reconize parent rows. Is there anyway to do this?
Recurrent tasks in a Gantt chart
Is there a way that you can plot recurrent tasks in a Gantt chart? E.g., writing a monthly report (1 day work) that is due every last Friday of the month. Thanks
Suggestion for dynamic lists
A feature that would be fantastic for large scale project work would be dynamic lists that could be set up on a sheet and then referred to by drop-down lists in other forms/sheets. E.g. As more projects or names are added to a sheet these then automatically populate drop-down lists for an "Add new risk" form.
Copying Rows With Attachments to Another Row in Same Sheet
Hello, I'm not aware of a current way to do this, so I'm hoping for quick solution. In our use, we find ourselves needing to copy and paste rows with attachments into a new category in the same sheet from one row to a new row and currently the only way I see to do it is to download the attachments and then upload to the…
