FILTER

KyleAnderson

Hi,

Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report.

I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all assets in "review" for Kyle

Google Sheets  =FILTER( $G4:$G13 , $H4:$H13 = "Review", $I4:$I13 = "Kyle" )

Thanks,

Kyle

Andrée Starå

Hi Kyle,

I'd recommend using a report and maybe the new Sheet Summary Report.

More info: https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary-reports

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD