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

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!