-
Sub-Row and Formulas
Is there a way to remove sub-rows from formula tracking? Ex: We want to track the general Task but not the detailed items below that task. Can we do this with a formula and generate a single metric number? Thanks for all the help!
-
Limiting Auto Number to Specific Range
Hi, I'd like to add an auto number column, but I would like to set the specific range in numbers. For example, I need the auto numbers to be between 0 and 250 without duplicating. Is there a way to set those limits? Thanks. Jay Duque
-
Calculating resource allocation for week or month view
As the resource view in resource management is only viewable by licensed users, and is in days, I'm interested to hear from other users how they were able to export data to excel and calculate for a week or month view. I've tried to export to excel but only see the grid info, no allocation % applied to dates (resource…
-
Automatically Adding Rows Based on Change in Another Sheet
I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet…
-
Index + Match + Cell Reference + Forms Question
Hi, I have two sheets for 2 separate processes in our production workflow. For each of the sheets I have forms for people to fill out. I would like to have it where the 2nd sheet is able to pull data from the first sheet. The 2nd sheet needs to see some of the same data as the 1st, but I would like to make it that people…
-
Need help with COUNTIF and #UNPARSEABLE error
I want to make a simple dashboard pie chart. I have a pipeline worksheet and I am setting up the COUNTIF formula but I keep getting the #UNPARSEABLE error. see the two screenshots. I looked up the smartsheet error page and it gives some insites but I think I have all the pieces. Any suggestions on what is missing? Thanks.
-
Changing google drive accounts.
Hello Community. I'm having difficulty de-linking from one google drive account and linking to another. I have revoked all app in my smartsheet profile and also de-linked in my google account; even when I do all that I'm still linked to my old google drive account. Any advice or suggestions? Thanks David
-
Automatically update form link when creating new folders
Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…
-
hiding a column
the hide column option is greyed out. I am an editor for the sheet, and overall the sys admin for the account
-
Predecessor Issue
Is anyone else having issues with the predecessors in SmartSheet? Right now, I have several sheets that have predecessors that have a duration of 1d and are following the row above without a 'type' (finish to start, start to start, etc.). As you can see from the screenshot, it has row 1 ending on 1/21 and row 2 start on…
