Skip to main content

App: SmartSheet

I have 2 sheets, lets call them A and B. I am copying data to sheet B, from sheet A, when a check box is marked true on Sheet A (using Zapier Filter)

I would like to add a task, or filter, to take cell criteria from sheet A, to see if it already matches any rows in sheet B before creating a new row on sheet B.

How can I return the row id from sheet B, if criteria from sheet A - column C matches any row in sheet B - Column B?

It does not appear to be possible yet, without any backend coding. Am I wrong?