Skip to main content
Question

Duration Formula with If Statement

  • September 16, 2019
  • 0 replies
  • 33 views
Hi All,

I have three kind of recruitment type : direct, open and restricted. 
Open recruitment must be following all the step from advertisement to contracted
I can count how many days for the process by [contracted date] - [advertisement date]

The problem is with above formula it can not count how many days for direct and restricted date because this two type is not following all the step.

I can achieve this by creating 3 different report with 3 different formula for each recruitment type

Restricted recruitment: [contracted date] - [selection panel date]
Direct recruitment: [contracted date] - [interview/assessment date]

It possible to create just one report for this case, probably with if statement?. How can I achieve this?

Many thanks

------------------------------
Syaeful Bahri
------------------------------
    This topic has been closed for replies.

    • AustinK
    • Quickbase Alumni
    • September 16, 2019
    if(
    [Recruitment Type] = "open", [contracted date] - [advertisement date],
    [Recruitment Type] = "direct", [contracted date] - [interview/assessment date],
    [Recruitment Type] = "restricted", [contracted date] - [selection panel date]
    )

    If you want it to have some kind of duration if there is no status you would do it like this.

    if(
    [Recruitment Type] = "open", [contracted date] - [advertisement date],
    [Recruitment Type] = "direct", [contracted date] - [interview/assessment date],
    [Recruitment Type] = "restricted", [contracted date] - [selection panel date],
    [other] - [duration]
    )

    You are going to want a formula duration field.
      Terms & ConditionsAccessibility statement