-
Can't Create a Single Grid Sheet anymore? Why did this change?
I am unable to easily create a grid sheet unless I do it through the Workspace panel. I used to be able to right-click anywhere in my sheets folder, for example, and add one, or hit the create button, which offered options. Now, the create option directs me to the same location as the left navigation, and there are so many…
-
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
-
Cell-linking from another sheet in the Predecessor column
Please enable the ability to use the cell-linking from another sheet in the Predecessor column. Importing dates from another sheet in a new row and then using them as a predecessor can disrupt the duration and critical path of the project. Thank you.
-
Critical Path using a Start-to-Finish predecessor
This is a scenario for projects where the finish date of the last task is dependent on the start date of a task/milestone (most likely from another project). For example, if the project is to decommission an application then disabling the application (last task) cannot occur until the new application goes live (start date…
-
Column Dependencies and Formula Auditing
I wish there was a way to select a column/ cell and see all formulas and automations that reference it. Similar to Excel's "Trace Dependents" and "Trace Precedents." This could all be part of a formula auditing tool that would let you see all formulas on a sheet and which column they are in.
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
How saved filters work
I'm requesting that the parameters of a saved filter not be updated when I use that saved filter, add some more filters to dive into the data more, update some data fields, then click save. Intuitively to me that "save" should have just stored the data updates and shouldn't have updated the parameters of the saved filter.…
-
Cross-sheet predecessor without using cross-sheet reference
In sheet 1 there is a date 1 which is a predecessor (SF type) for last task in sheet 2, so that date 1 is later than any task in sheet 2. When I use a cross-sheet reference to import the date 1 into sheet 2 and then simply use it as a SF predecessor, it does two things that I need to avoid: it erases the critical path for…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.