Get a row according to a column value
Google Sheets
Action
Extract first row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- Column A {{column_a}}
- Column B {{column_b}}
- Column C {{column_c}}
- Column D {{column_d}}
- Column E {{column_e}}
- Column F {{column_f}}
- Column G {{column_g}}
- Column H {{column_h}}
- Column I {{column_i}}
- Column J {{column_j}}
- Column K {{column_k}}
- Column L {{column_l}}
- Column M {{column_m}}
- Column N {{column_n}}
- Column O {{column_o}}
- Column P {{column_p}}
- Column Q {{column_q}}
- Column R {{column_r}}
- Column S {{column_s}}
- Column T {{column_t}}
- Column U {{column_u}}
- Column V {{column_v}}
- Column W {{column_w}}
- Column X {{column_x}}
- Column Y {{column_y}}
- Column Z {{column_z}}
- Number of Row {{row}}
- Sheet name {{sheet}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.