Forum Discussion
formula for conditions (within date range AND including text)
Hi there, I'm looking for a formula that extracts information from a spreadsheet which is: - between 2 dates from 1 column and includes a text from another column e.g. dates 1/7/2021-30/6/2022 ...
Hi there, thanks for this but i am not trying to filter but to extract this information so it shows up on the dashboard tab.
I am not sure where this is going. By filter, I am referring to a formula that is placed on another sheet, in this case the dashboard, and reproduces an extract from the source data. It is not simply a case of hiding some source data from sight.
Since it is a dashboard, it is unlikely that you will want a set of complete database records but that is achieved by applying the filter formula to the specific fields you wish to display.
Since it is a dashboard, it is unlikely that you will want a set of complete database records but that is achieved by applying the filter formula to the specific fields you wish to display.
- If that is what you mean by filter then yes that is what i'm referring to. The dashboard is another sheet used for the extracted information.