Simple If with @row - Why won't this work?

Doyle54

Andrée Starå

Hi Carey,

Try this one.

=IF([Pad Match]@row = [Pad Match2]@row; Found@row+1)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Doyle54

Andre - What I want to do is see if the Pad location in that first Pad Match cell matches any of the 344 Pad records. So, I appreciate the thought. Is there any way to simply use one cell and compare that to an @row column?

C

Andrée Starå

@Doyle54

Ok.

Try this.

=IF(COUNTIF([Pad Match2]:[Pad Match2], [Pad Match]@row) > 0, 1)

Did that one work?

Doyle54

@Andrée Starå - Thank you for trying. Correct me if I do not read your logic properly. Your statement logic states count the number of [pad match] are found and if the count is greater than 0 put a 1 in the Pad Match cell. Close and I can use the code elsewhere but not what I need right now. Need: For each new record input, 1) see if there is a matching Well Pad (1-344), 2) Update the Well Pad Found@cell. This allows me to see if a Field Officer is duplicating his Well Pad inspections before finishing his allotted Well Pads to visit for that quarter.

 I am trying to make sure each pad is inspected at least once in a quarter.

  =IF(COUNTIF([Pad Match2]:[Pad Match2], [Pad Match]@row) > 0, 1)

My input into the Comment Field is getting corrupted somehow. What do you think of Parent Children relationships and if they can be the solution? Studying that idea.

Doyle54

Do i have to always input into the dropdown input option or is there a way to simply reference a column in the sheet that has the options?

Andrée Starå

@Doyle54

Did you get it working?