-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
Unwanted Default gray background of the dropdown selections
Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray background gone please
-
Index Match Function Help
Hi Smartsheet Gurus, I am attempt to pull information from one sheet to another given a set criterion that is present in both. I believe that either a VLOOKUP or INDEX function should suffice but cannot seem to get things to work. A little background: We would like to be able to have employees enter a form with data about…
-
If cell matches string criteria in one column, THEN return value of another column (same row)
Hello all, I have the following problem. In my first Smartsheet under the column "Revised Catalog Release" I want to output a date value if a criterion is meet. Now this is the other sheet I am referencing: In lay man words what I want is: If column "Task Name" = "Packaged Part Catalog Release" then please return the value…
-
Is there a way to have data from one sheet auto update the start & finish date within a schedule?
I have built a schedule with proposed start/ finish dates (which are driving the Gantt) as well as a column for the actual start/ finish dates. I can link the actual columns to the data sheet where teammates are inputting their actuals, but those columns do not drive the Gantt chart to show if any lag has occurred. I am…
-
Nested Criteria on COLLECT
I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([Economy QTY]@row * (INDEX(COLLECT({Price Range}; {Type Range}; "Economy"; {Route Range}; CONTAINS(Route@row; @cell); {Active…
-
Combine Cross-Referenced Sheets
Hi - I have 6 Summary sheets that are cross referenced to 6 Regional sheets. These have formulas gathering totals by person. Sort of mimics a pivot table. Works great for stacked bar charts. I'd like to combine all the totals for each person in one sheet. People might appear on more than one Summary sheet. The names may…
-
"Locking" an Index/Match formula
Hi, I am using an index/match column formula to look up an approver from another sheet. This is working fine, but I am going to need to change an approver and want to keep the previous approver listed for the past records. Does anyone have any suggestions on how to do this? I would rather not create a new column or copy…
-
Linking numerous cells from one sheet to another (GC Bids)
I have a source sheet that has 18 parent rows. There are many child rows per parent. I have helper columns to analyze the data in the source sheet. I have created SUM(CHILDREN()) on each parent row. I now need another sheet to perform calcs on each of the parent rows, however, this second sheet (destination sheet) does not…
-
Auto populate cells
I have a smartsheet named GSA EIS_MAS_Features_Services Matrix and I need to auto populate cells based on information in another sheet named GSA TAM Contract_Features_Services_Resource_Matrix. I have tried Index and Iferror but it keeps erroring out.
