0

I am trying to get this formula to work.

I want: IF column ärende tilldelat is blank I want the calculated column to say "Ej tilldelad".

If you have chosen "Tillkoppling" in the column Ärendetyp I want it to say "test".

 =IF(ISBLANK(OR([Ärende tilldelat]);"Ej tilldelad";([Ärendetyp="Tillkoppling";"test";TEXT([Ärende tilldelat]-[Ärende inkommet];"hh:mm:ss")))

IF "Ärende tilldelad" ISBLANK display "Ej tilldelad" in the calculated column

Else IF choosen "Tillkoppling" in column "Ärendetyp" display "Test" in the calculated column.

2
  • What is the data type of ärende tilldelat and Ärendetyp columns? are you getting any error using above formula? Commented Jan 24, 2020 at 9:41
  • I get syntax error. "Ärende tilldelat" is a plain text column and "ärendetyp" is a dropdown choice column
    – 288088
    Commented Jan 24, 2020 at 9:45

1 Answer 1

0

According to my understanding your requirements are (correct me if I am wrong):

IF [Ärende tilldelat] is blank then calculated column = "Ej tilldelad"
Else IF [Ärendetyp]="Tillkoppling" then calculated column = "test"
Else calculated column = difference between [Ärende tilldelat] and [Ärende inkommet] in format of "hh:mm:ss".

Try using below formula:

=IF(ISBLANK([Ärende tilldelat]);"Ej tilldelad";IF([Ärendetyp]="Tillkoppling";"test";TEXT([Ärende tilldelat]-[Ärende inkommet];"hh:mm:ss")))
10
  • This kinda worked. It still says "Ej tilldelad" If I have choosen "Tillkoppling" but when i put in a value in "Ärende inkommet" is says "Test". I would like it to know directly if it should say "Ej tilldelad" or "test".
    – 288088
    Commented Jan 24, 2020 at 9:55
  • Please add all the possible conditions you want to cover in your question. It will be easier to answer your question. Commented Jan 24, 2020 at 10:03
  • Sorry if i'm giving you a hard time. I've edited my question
    – 288088
    Commented Jan 24, 2020 at 10:13
  • What is the 3rd possibility? If [Ärende tilldelat] is not blank and [Ärendetyp] is not equal to "Tillkoppling" then what should be the value of your calculated column?? Commented Jan 24, 2020 at 10:23
  • It should just be the value [Ärende tilldelat] - [Ärende inkommet] it shows "hh:mm:ss"
    – 288088
    Commented Jan 24, 2020 at 11:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.