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”
Name the column that will contain the match flags 1-true, empty-false