Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 09, 2023 05:02 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 09, 2023 05:43 AM
Hi,
I hope this may help. I created two tables
- 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)
- 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!