I have been trying to think of a way to get around Smartsheet's lack of a =FILTER function?

Austin Marsland · 07/02/21

I have been trying to think of a possible work around for an =FILTER type function, I have been using Smartsheet for a few months now and the last thing I need before I can fully move over to Smartsheet from google sheet and excel is a auto-generated summary sheet based off a a row in another sheet. I will attach some pictures below but I really just want to be able to click a checkbox for a single row and have a contract summary form be autogenerated like I had in google sheets using the =FILTER function.

Contract Summary WO 35 for Smartsheet.pdf

Bassam Khalil · 07/02/21

Hi @Austin Marsland

Hope you are fine, you can use Index with Collect Function

I have been trying to think of a way to get around Smartsheet's lack of a =FILTER function?

Answers

Help Article Resources

Categories