An equivalent of the FILTER function in Excel? =FILTER (array, include, [if_empty])

Dai Vo Tien

Could you share me the function an equivalent of the FILTER function in Excel? =FILTER (array, include, [if_empty])

Thanks so much !

Mark Cronk

Hi, The closest functions in Smartsheets are COLLECT, SIMIFS and COUNTIFS. All let you extract data using mtiple ranges and criteria.

Details her:

https://help.smartsheet.com/functions

Help?

Mark