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 ...
Are you trying to filter the data? If so, perhaps
= FILTER(
Table,
(ReferralDate<=1/7/2021)*(ReferralDate>30/6/2022)*(InWork="Y"),
"No results"
)
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.- 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.