Nov 8, 2021 · I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community …

Jan 27, 2023 · INDEX/MATCH/MATCH is more for referencing an entire table where you need to match on both the horizontal and vertical axis. INDEX/MATCH is for pulling from a single …

Jan 1, 2022 · Smartsheet Support had provided me with the below formula but I can't figure out what pieces and parts of my tables should be included in the Ranges. =INDEX ( {Table of …

Apr 30, 2020 · The Index Match works fine I just need to add the first condition with an IF statement. See my formula below. Project Type = First condition A&E and assigns the …

Apr 25, 2023 · The formula in my example is this: =INDEX ( {whole_sheet}, MATCH ( [Variable 1]@row, {project number}, 0), MATCH ( [Variable 2]@row, {headers}, 0)) If this doesn't help …

Jun 25, 2020 · Hey All, Reaching out to the masses to hopefully get some help. I need to pull information from sheet 1 into sheet 2 using the INDEX and MATCH functions. Sheet 1 that I …

Nov 27, 2018 · Hi , How to use Index and Match function in SS.Please advise with an example

Feb 24, 2022 · I am familiar with Index-Match, but what I'm looking for (to "match" with the first column in Sheet 2) won't be a match. So in Sheet 1, I want to use a formula that looks for the …

The Index Match alone works correctly, but when I try to include the IF Statement for the No Changes column, the example I posted says not quite right, when I tried your option it returns …

Oct 12, 2022 · You can use index/match with checkbox columns but I believe you are doing it incorrectly. You would want to do something like =INDEX ( {checkbox column},MATCH ( …