IF AND OR formula

[fernandaalvaren]

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

[cesrua1]

Hi,

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!