Hi friends
I need to show the values which should be filtered by two columns
And more over that should be in calculated Column
I am using this below expression but I didn't get my result.
IF CONTAINS ([RESOLUTION],"HIGH") AND CONTAINS ([TYPE],"COMPLAINT") THEN [NAME] END
This expression give output as values of NAME where [Resolution] = "High" it didn't consider [TYPE] can you please help me on this how can I write condition by using two columns and show the Single value
Please help ASAP its too imp..
6 answers
Your calculation formula Working for me.
Thanks,
Shin
9.0 attached