Pull Data from Master sheet to another sheet

Hello,

I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor list. Does anyone have suggestions on how to go about doing this?

I appreciate any assistance.

Miki

Find more posts tagged with

Sheets

Formulas

Support

Community Platform

IT & Operations

Conditional Formatting

Project Management

Comments

Paul Newcome

Have you looked at creating a Report?

Andrée Starå

Hi Miki,

It sounds to me like a report would work for your use case or connecting the sheets with cross-sheet formulas or cell-linking.

Would any of those methods work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Miki Jeffers

Yes, I need to work with the data to build a dashboard and using a report has it limitations. For example I can't use the metric widget from a report.

Paul Newcome

Ok. How many vendors do you have, and how frequently does the number of checked off vendors change?

Paul Newcome

Also... What is the purpose behind specifically using a Metrics widget on the dashboard?

Andrée Starå

To add:

Another option might be to use the third-party service, Zapier, to copy the information to the other sheet.

Is that an option?

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?