Hello, I want to create a function that checks if in an excel Data table in a row the cell in column A is filled + in column B if the cell says “order executed”. How do I write this together in one if statement? Thank you!

Check two columns in datatable

grant.grisham (Grant Grisham) November 15, 2022, 3:38pm 9

I agree with Edwin. Use the filter data table activity. Don’t try to be a one-line hero when it’s not necessary.

Topic		Replies	Views
Identify empty cells in DataTable Help datatable , excel , activities , question	6	2080	November 21, 2019
Check if a datatable contains rows with Null or Blanks in any Column/Cells Activities datatable , excel , activities , question	2	4887	May 10, 2021
How to Check Excel 2 null or empty Columns Academy Feedback	13	2667	April 23, 2019
Condition to check the column is blank or not in datatable Studio datatable , studio , question , linq	5	400	January 15, 2024
Query to remove datatable Activities excel , activities , question	7	345	June 6, 2023