Is it possible for workflow to reference all rows in a formula from a dynamic spreadsheet?

AkisM

The spreadsheet has only 2 columns (description, serial number), and rows from 1 to 1000+. It is updated daily with rows being added/removed.

Is it possible to somehow have a formula in the workflow that goes through every row, checking the dynamic spreadsheet's description against a static input that's specified in the workflow, and if matched, appends serial number next to that record?

Something like If Contains([StaticDescr], [Descr_DynamicSpreadsheet]) then [SerialNoDynamicSpreadsheet]. I'm just not sure how to write the formula so that this check is performed using all descriptions from dynamic spreadsheet.

Thanks in advance for your help.

BrandonB

Couldn’t you use the append tool to put this static value on every row and then use a formula tool to check your values against the appended value?