Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: IF AND OR formula

411 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello community,

I want a formula who counts how many successful candidates (the ones who gets "A" and "AAA") I had today.

I was thinking about: 

IF(AND({Date 1st Interview}, TODAY(), {1st Round Bewertung}, "A" OR "AAA", COUNTALL())

But I know the "or" command is on the wrong place.

Can you help me? thank youu

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast


I hope this may help. I created two tables

  1. Candidates--> I guess you have more fields but for your problem i needed 3:
    • Date of first interview as a date field
    • 1st Round Bewertung as sigle select field with all the possible qualifications
    • First round marker that marks the candidate when it passess the first round and links the record to the other table. (I guess you'll have more than one round)
  2. Rounds metrics: Where you configure the metrics for each round



The metric you want I configure as a rollup field with this configuration:


Hope it helps!