Flag rows with formula

Flag rows from the dataset based on the result of a formula by creating a column containing ‘1’ for all matching (in-range) rows. Unmatched rows are left empty.



Write a formula by which to evaluate each row for a match. The row matches if the result of the formula is considered as “truish,” which includes:

  • A true boolean

  • A number (integer or decimal) that is not 0

  • The string “true”

Flag column

Name the column that will contain the match flags 1-true, empty-false