Skip to main content
Question

IF Formula or automation? I want to see a result of "Exists" or "Missing"

M
Forum|alt.badge.img+1

Hi All, very new to AT!  But this has been an incredible community but I haven’t been able to find an answer to this question:

I have a column on Table A called “System A Identifier”

I have a column on Table B called “System B Identifier”

 

The column on Table A will ALWAYS have more data than the one in Table B.  I would like to create a Table C that links to the “System A Identifier” in table A and a new column that shows me a “Exists: or “Missing” value if that record is available or not based on the field “System B Identifier” column.

 

I think an IF formula is the way to go, i just have not been able to figure it out.

 

Thanks!

    3 replies

    TheTimeSavingCo
    Forum|alt.badge.img+28

    Hmm does this look right?

    •  

       

    And the formula in use is

    IF(
  {System A},
  IF(
    {System B},
    'Exists',
    'Missing'
  )
)

    And I’ve set it up here for you to check out

    Adam, Consultant @ thetimesaving.company
    Alexey_Gusev
    Forum|alt.badge.img+23

    Hi,
    Duplicate  “System A Identifier” column, turn duplicate into linked field (to a Table C)
    Do the same with “System B Identifier”
    In Table C, you will get 2 linked columns, where link to A will be filled 100%(unless you have something in B that not exists in A), link to B partially filled.
    you can add formula like  IF({Link_to_B_field _name}, ‘Exists’, ‘Missed’) 
    Note that if you add new records in A or B after that, you should provide their link to C

    Mike_AutomaticN
    Forum|alt.badge.img+23

    Hey ​@martinca, as a rule of thumb if something can be solved using a formula rather than an automation you will always want to go down that path.

    Automations might error for different reasons, and they also have certain limits (automation count, and run count) which you want to stay away from!  

    Mike, Consult @ Automatic Nation

    M
    1 person likes this
    • M
      martinca

    Reply


    Most helpful members this week

    Terms & Conditions