Indexing from different sheet with qualifier


I'm trying to pull certain cells into a new sheet, but having issues with the syntax.

I'm referencing two columns, Test Name and Status, and trying to pull in all Test Names where the status is 'Live'.

My current formula results in #UNPARSABLE

=INDEX({Opt Roadmap1},COLLECT([Test Name]:[Test Name],MATCH("Live",[Status]:[Status])))

I know it would be simple to create a Report with a filter, but leadership is adamant on using Card View.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!