-
Indexing & Sheet Updates
Anyone that uses sheet to sheet indexing noticing that sheets are not updating unless you open, save and refresh the data sheet that is the source sheet? We have had several team members reach out to let us know that their dashboards and reports are not updating due to this situation.
-
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)
-
Contact Field in Index Match Returning Strange Values
I have a project plan template that is created through the control center. The owner of certain tasks is dependent on what department the project is in. I have a background sheet that is a task owner crosswalk, and then on the project plan it will run an index / match to pull the correct owner. This has been working fine…
-
Fix #INVALID COLUMN VALUE error when using Index Match in a different column type than source sheet
Hello! I am curious if there is a solve to the #INVALID COLUMN VALUE error I get when trying to pull a value from another sheet using Index Match, and both the source sheet and current sheet have different column types. I am currently using the following formula: =IFERROR(INDEX({OChM - Intake - Intake Meeting Date},…
-
Help with index/collect (or maybe something else?)
Hi, I am struggling with index collect. I'm wondering if what I'm trying to do may not be possible with Smartsheet but I'm not giving up until I ask you wonderful people! I have a large Smartsheet with many columns and I'm maxed out at 381 columns, my license is only to 400 columns so while I could probably figure this out…
-
Help With Index-Collect and Cross Sheet Referencing
Hi all, I am attempting to return a Contractor's name from a source sheet using multiple criteria (if they are subcontracting and what their scope of work is). The issue I am running into is the unique ID I use to connect the sheets (The PCM Number) has duplicate values when there are subcontractors (multiple contractors…
-
Indexing Help
I need some help getting this to pull the right data. I have two sheets: PACE Appeals and Grievance Reference that I want to link. In PACE Appeals I want the 'Dept Contact' cell to bring back an index match based off of 'Dept Responsible For Follow-Up' & 'Center' (The first column is label Center it just isn't showing up…
-
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…
-
Is this a bug and if so, how do I mitigate it?
I have a formula to autopopulate a drop-down list field to show one or more items, grouping together a number of related rows in another table. =JOIN(INDEX(DISTINCT(COLLECT({EcoTech Activities Managers}, {Activities PIDs}, =ID@row)), 0), CHAR(10)) Basically collect the names of managers from another table where the key…
-
Using multi-select dropdown list as criteria for Index/Match Lookup with SUMIFS
Hi all — Looking for some guidance on the below… I have a sheet named "Tracker" with a dropdown column of job levels (named "Target Audience") and another column that I am wanting to sum the job levels from whatever is selected for that row ("Total Target"). The totals for each job level are pulling from as a cross sheet…