I have a formula column of data type choice. If I write a simple condition everything works. For example:
If(Name = "Test",
Unterlagenstatus.'liegt vor',
Unterlagenstatus.'liegt vor'
)
As soon as I add a second condition I get an error message:
If(Name = "Test",
Unterlagenstatus.'liegt vor',
If(Name = "Test",
Unterlagenstatus.'liegt vor',
Unterlagenstatus.'liegt vor'
)
)
Error: The operation cannot be performed on multiple Option Sets. Please use single Option Set as result type.
If I convert it as follows, the error doesn't occur.
If(Name = "Test",
If(Name = "Test",
Unterlagenstatus.'liegt vor',
Unterlagenstatus.'liegt vor'
),
Unterlagenstatus.'liegt vor'
)
Can someone explain to me what I'm doing wrong? Or is this a system error?