OMG, I think this did it! Thank you John! Yes I was looking for an update (YES/NO Checkbox being checked YES) in a specific CELL (14:K for example…Row 14, Column K…“Cable Abs” row, “Workout #6” column in my example) to trigger the email workflow. And NOT to send email when the checkbox was checked in any of the other Rows in Column K. Just that one specific CELL in that specific Row.
John, your AND( [RowAttribute]=“UniqueValue”, addition allowed me to specify the specific ROW, and the [_THISROW_BEFORE].[QueriedColumn] <> [_THISROW_AFTER].[QueriedColumn] ) specifies the specific COLUMN. Brilliant! I was just missing the syntax to specify which ROW.
By the way, For AND( [RowAttribute]=“UniqueValue”,
The RowAttribute is the Column NAME of the first column (specific to your individual spreadsheet.) And the “UniqueValue” is the text that appears in the specific ROW you are trying to trigger.
So the first part of my condition now reads AND( [2 SETS OF 10 REPS]=“Cable Abs”, It took me some playing around with UniqueValue and RowAttribute to figure out that I needed to replace the words ‘RowAttribute’ with the text that is specific to MY spreadsheet (2 SETS OF 10 REPS). And replace the words ‘UniqueValue’ with the text that appears in the cell in Row 14 of my “2 SETS OF 10 REPS” column (Cable Abs).
Now, when the checkbox next to the Cable Abs exercise in Workout #6 is checked, only then will the workflow send me an email saying “Workout #6 is complete.” which is exactly what I wanted it to do!
I hope my explanation makes sense and might help others who are having similar questions and confusions with this particular behavior.
Thank you to all who chimed in to help!!!