Quick Column Icon Question

HCL Domino Domino Forum
1

Hi,

First of all I do apologise if this is really something simple…

I have an embedded view which displays the status against a task carried out. On the embedded view there are 3 action buttons “Successful”, “Failed” or “Unknown” that enable the user to change the status.

Im presently using icons within the column to illustrate the status. What I would like to know is how do I write the formula so it displays the icon for all 3 statuses. So far I have only got it to display 2 icons. I have tried adding the column number 150 to display the icon for the “Unknown” status at the end of the formula below but this does not appear to work.

@If(status != "Successful ";81;82) ----Displays a tick for sucessful and a cross for failed

Is it possible?

Cheers,

Gem

2

Subject: Quick Column Icon Question

@If(status = “Successful”; 82; status = “Failed”; 81; 150)

3

Subject: RE: Quick Column Icon Question

Hey

Thank you both for your responses.

Ive tried both out but Im not able to display the tick sign for when the status is ‘successful’?

The other two icons appear to display correctly.

Any ideas?

Thanks,

Gem

4

Subject: RE: Quick Column Icon Question

Check spelling and/or case.

5

Subject: RE: Quick Column Icon Question

use 168 for tick sign.

6

Subject: RE: Quick Column Icon Question

Actually there is no need to change to 168 for a tick as 82 is also a tick sign. See Chart below for full listings (6.5.4 chart, more have been added in since.)

7

Subject: Quick Column Icon Question

are you asking for this.

@If(

status = “successful”;83;

status = “unknown”;150;

status = “failed”;81;