Hello, great Smartsheet community!
Could you please, help me to create a function that extracts data from another sheet, but only for data within a filter in question. This is what I have:
Sheet 1:
Columns: "Active" (Star), "Country+Disease " (text), "Status" (dropdown list, single value).
There are duplications of the values in the column "Country+Disease" with associated "Status" values. The rows of interest to me are filtered by a presence of a mark in "Active".
Sheet 2:
Columns: "Country+Disease " (text), "Tracking status" - the Vlookup column.
I am interested in receiving the values from the Sheet 1, "Status", only from the rows which have a star in the "Active".
In Sheet 2's "Tracking status" I use "Country +Disease" data as a search value to gain "Status" from Sheet 1. Naturally, I receive the value from the highest row in "Status" column in Sheet 1. I need only the filtered, Active ones.
I saw similar issues in this website, but they were so specific to the users, that I spent hours trying to fit it to my needs and failed. Please, help.