CAPTURE VALUES FROM ONE SHEET AND POPULATE ON ANOTHER BASED ON A KEYWORD

JSMITH2

Hi, I am trying to capture equipment number, year, make and model from my main sheet based on the status "available for transfer" and bring those values over to my calculation sheet to display on my dashboard. Below is what the main sheet looks like that I want to pull those values over to my other sheet based on the status "available for transfer"

Paul Newcome

How exactly were you wanting to populate it on your dashboard? Reports can be dropped onto dashboards and (if structured properly) used to populate graphs/charts.

Paul Newcome

Have you looked into creating a row report?

JSMITH2

it needs to be a formula that will look for status "available for transfer" because equipment will constantly be changing status, dont believe row report would work.

Paul Newcome

You can create a filter in the report that will pull all rows that have "Available For Transfer". The report will automatically update as data changes in the sheet.

JSMITH2

I understand that a filter has this capability, I need to bring this data over to a separate sheet in order to populate my dashboard

Paul Newcome

How exactly were you wanting to populate it on your dashboard? Reports can be dropped onto dashboards and (if structured properly) used to populate graphs/charts.

JSMITH2

Paul,

The report was the way to go for this. Thank you for the help, appreciate it!

Paul Newcome

Happy to help. 👍️