-
Re: Delete Rows using an Automation
I appreciate all the workarounds people have posted, and I use several variations across different sheets and workflows. However, I would still like to have an action for "Delete Rows" as a…2 · -
Re: INDEX MATCH ERROR WHEN CONVERTED TO COLUMN FORMULA
Hi Simone, I would first look at using @row for your MATCH search value. For example =INDEX({SHEET 2-Col. B}, MATCH([SHEET1-Col. A]@row, {SHEET 2-Col. A}, 0)) Unless you intend to have the search val…1 ·