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

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

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Carey,

    Try this one.

    =IF([Pad Match]@row = [Pad Match2]@row; [email protected]+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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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åAndrée Starå ✭✭✭✭✭

    @Doyle54

    Ok.

    Try this.

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

    Did that one work?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Doyle54Doyle54
    edited 06/29/20

    @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 [email protected] 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.

  • 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åAndrée Starå ✭✭✭✭✭

    @Doyle54

    Did you get it working?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.