-
Column Finder
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…
-
Getting Data From Another Sheet to Populate in Another Sheet when Conditions are Met
Hello, I currently have 2 sheets that I am working with: the first is the "Original" sheet and the other is a "Metrics" sheet, which pulls data from the original (being used for Dashboard charts). The "Original" sheet has an "ID" column, a "Status" column (either "OPEN" or "CLOSED"), and "# of Days" column. On the metrics…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
Moving Sheets Automatically
Is it possible to set up a workflow that moves an entire sheet or report once certain parameters are reached? For example: if SheetA hasn't been opened in the last 3 months, can it be automatically moved to an "Old Data" folder in the same workspace?
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
-
Merged: Editable column formulas
This discussion has been merged.
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
