Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Pull Data from Another Sheet based on Criteria

edited 12/07/23 in Formulas and Functions

Hello,

Below is my master file of projects. I've filtered to show all the values based on "Automation" in the Drop Down column. Each project is designated with a project #.

I want this sheet to function as a way to automatically carry over all the project #s from the master file to my new file (see below) based on all the projects designated as "Automation" in the Drop Down column.

For context, I tried to use INDEX MATCH based on the matching for "Automation". However, it's only capable of pulling over the first value.


Is there any way for me to achieve this task without creating a workflow?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions