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

