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 · Accepted solution]

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?

[AkisM]

Indeed, that's a very simple solution that works just fine for this purpose @BrandonB . Thank you!